Sort date 2 column

Have an sql puzzle that is so classical it could be text book.

Column1 is Date
Column2 is Amended Date

There is always an entry in Column1 - there is occasionally an entry in Column2.

My query needs to return the records in chronological order - and the Amended Date is to be used when it exists in terms of that record's location in the chronological order. (One can presume that the Amended Date is always correct and doesn't need to be compared with its own original date.)

Am going to nick away at some sql statements and would welcome input from anyone out there that likes an sql puzzle...thanks in advance ntc

Hi NTC,

Do you look for a sql select like below?


select
*
from CustomerSupports
order by
ISNULL(SentDate, SupportDate) desc

Eralper
http://www.kodyaz.com