Thanks Jack and Jody.

Jody's example also works, and using 'convert' works on an individual basis when I pull out a row or two of data.

But when I query from the...

I do the following:

select value from table

where name = 'DateTime'

and IsDate (value) = 0

And no rows return. This should indicate that all the string values is recognized as a valid...