andell_ramsay (12/15/2010)
Jeff -How then would one be able to sort chronologically on this field? Is there a way to keep the format while changing the data type to a numeric format?
To answer the questions above in order... You can't and yes. 😛
See the following SQL Spackle article for one way to do this...
http://www.sqlservercentral.com/articles/T-SQL/71511/
--Jeff Moden
Change is inevitable... Change for the better is not.