ISNUMERIC()

If expression is numeric returns 1, if not numeric returns 0.

SELECT ISNUMERIC(100);

Output:
1

SELECT ISNUMERIC('sql1');

Output:
0

SELECT ISNUMERIC(20*3);

Output:
1