Hi Steve,

Hope I got this right. So we can  use a statement like this:

select top 5

 o.orderid

 , o.customerid,requireddate

 , CONVERT(char(10), o.requireddate, 103) as requireddate

 from orders o

 order by CONVERT(DateTime, o.requireddate, 103) Desc

I tried...

Its fantstic option to make data dictionary into database itself.

Thanks,

Kiran Patil