Hi Experts,

I am getting a error when i am writting this query

Select * From Status_Checklist

Order By Convert(DateTime, Medical_Advisor_Received_Date, 103) DESC


In the database "Medical_Advisor_Received_Date" field is defined as
varchar(10) and many rows are null for this field. I am working on SQL
server 2005.

So if any one havin any idea about this then please me.

Regards
Dinesh