[SQL] Convert CHAR datatype to DATETIME for use in query

I have a CHAR field that contains a date,(yes, I know). I need to be able to first convert the value from a char to datetime and the use that resulting datetime to select from the table.

Any help would be appreciated. Thanks

Continue reading...