Is numeric doesn’t always return your expected value.
Example:
SELECT ISNUMERIC(',')
SELECT ISNUMERIC('4D177');
Use TRY_CAST or TRY_CONVERT instead.
Is numeric doesn’t always return your expected value.
Example:
SELECT ISNUMERIC(',')
SELECT ISNUMERIC('4D177');
Use TRY_CAST or TRY_CONVERT instead.