• If you are sure that the data in there are all valid dates, you can just modify it using SSMS to date feild.

    Another option is to add another column with datatype Datetime and then populate it with a convert to Datetime. Drop the old column and rename the new column to the old column

    -Roy