In SQL, if you’re not sure if a value can be cast to a certain datatype there are some built-in functions that can help you out. Take the following construction, where col_Value is a CHAR(4): 1: SELECT CASE ISNUMERIC (col_Value) 2: WHEN 1 THEN CAST...