I have a table called 'users'
an nvarchar (25) field named 'visaexp'
and a datetime field named 'visaexpd'
The visa exp may have data such as : "NA" or "01/01/2012" etc. Some are actual dates.
I need to run a script that will copy the data from visaexp to visaexpd IF the value is a date