Our database contains a table called accountinfo with a column called fields_4 the current format is this:
This is what we would like to have.
We need to keep the format in varchar for scripting reasons not date format.
I was thinking something like this
Set Date_Field = Convert(datetime, VarChar_Field, 101) .