CODE EXAMPLE FOR SQL

check if string is a number sql

Select CASE WHEN isnumeric([fieldname]) THEN 'Valid' ELSE 'Invalid" END