I would like to test if a column conforms to a particular format type, and then convert it only if all is okay.
select case when isdate([COL4]) = 1 then convert(datetime, [COL4], 112) else NULL END AS field1
In addition, select ISDATE('21/11/07') returns 0 and select ISDATE('11/27/07') returns 1.
obviously server is set to US format... but I would like to be able to select from text + convert when possible + not fail for a large select statement.
any help appreciated.