1) SELECT PARSE('249.000' AS INT) AS ParseAsInt This will return result as 249 2) SELECT PARSE('A249.000' AS INT) AS ParseAsInt throws ERROR because of invalid data SELECT TRY_PARSE('A249.000' AS INT) AS ParseAsInt returns NULL