Link to home
Start Free TrialLog in
Avatar of Rowdyone52
Rowdyone52

asked on

Catch SQL Cast ERROR

I need to find all instances where a field cannot be cast to date time.  How can I select all fields that fail the cast?
ASKER CERTIFIED SOLUTION
Avatar of Patrick Matthews
Patrick Matthews
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SELECT YourColumnNameGoesHere
FROM YourTableNameGoesHere
WHERE ISDATE(YourColumnNameGoesHere) = 0