I got a problem. <BR><BR>I got a field in MS SQL 2000 DB thats a nvarchar. This field is a "User defined field" It can be anything basically.<BR><BR>I am using this fields to enter a date in this format "mm/dd/yyyy" (mm does not have a 0 if the mm is lower than 10.)<BR><BR>How can I sort this field as if it was a date?<BR><BR>Any help would be appreciated Greatly.<BR><BR>1. NO I cannot change the nvarchar to smalldatetime.