Well the problem is EXPD will always throw off a smalldatetime conversion. Do you have a select list of these other expressions? Can you make the data more standard on the types of other expressions allowable? I don't think there is a time checker function that checks to see if the time is a valid time, but you could create your own function; if a valid time, return the time, otherwise, return null or an empty string, or zero.
Brian
|
Date conversion
