forjonathanwilson (6/23/2010)
null date can be cast as null string, but not the other way, interesting.:hehe:
This is not correct. A null string can be cast as date (result will be NULL). The problem starts when you try to case a non-null string as date - in that case, the string must evaluate to a valid date. And obviously, the string 'Test' does not qualify there.