Order By time question

[bminaeff]

Hi all,

I have a requirement where I get a time in "HH:MM AM/PM" format so for example I might get three times of "11:55 AM" , "12:39 AM" and "1:05 PM" sent over to me. I have to log this to a table and sort it in descending order. The problem is that the "1:05 PM" is then placed below the "11:55 AM" record. In my table I have the column set as an nvarchar(50) since my time may also be a string like "Unknown".

Any ideas how to correct this?

Thanks
-Bill

 

[genomon]

If the string is a valid datetime (ISDATE()), order it by Cast(strDate as smalldatetime)

"Artificial Intelligence is no match for Natural Stupidity"

 

[bminaeff]

That works great, thanks alot genomon

 

[genomon]

SWEET!!


"Artificial Intelligence is no match for Natural Stupidity"