What do you mean? Do you want to cast as datetime then sort or what?
Look up cast and / or convert in BOL

-----Original Message-----
From: cholo [mailto:mssqldba-ezmlmshield-x55723999.[Email address protected]
Sent: Monday, February 27, 2006 6:37 PM
To: LazyDBA Discussion
Subject: sort varchar as date/time




how can i sort a varchar field so it sorts as date/time







---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



MS Sql Server LazyDBA home page