I'd like to convert a free text date to 'mmddyyyy' format.
The free text date are in different format: 10/12/11, 8/25/2010, 1/3/13.
You can't do that in one simple SQL. You have to cast the text and there is only one format that you can define while casting.
You probably need to write some routine (SP or UDF) to get that or may be find one that has already been developed.