I have a column in SQL Server 2000 table that was created as a varchar(10).

It stores a date. The records that get imported into this table are created externally and the date format can literally be anything from 1/1/2010 to 01/01/2010 to 01/1/2010, to 1/01/2010 ect.

The program that does the import is not mine and I have no control over it source so I can't control the formatting at that level.

I do, however, have control over the SQL Server table that the program dumps data into. I would like to know if it is possible to run a query (maybe an UPDATE query) that would reformat all the dates in the column to mm/dd/yyyy.