Discussion Forum | Board Infinity

Structure language query numeric function

what is the function to check if the field has numeric value or not?

The ISNUMERIC() function tests whether an expression is numeric.

This function returns 1 if the expression is numeric, otherwise it returns 0.
Ref: https://www.w3schools.com/sql/func_sqlserver_isnumeric.asp#:~:text=The%20ISNUMERIC()%20function%20tests,numeric%2C%20otherwise%20it%20returns%200.

2 Likes

Describe table should also help u to know datatype
ref:https://www.geeksforgeeks.org/sql-describe-statement/

2 Likes

sir there is another operator which you can do same thing is REGEXP ‘[0-9]’.

1 Like

Great sagar keep sharing ur knowledge

ISNUMERIC() gaves i think expression is numeric or not by gaving output 1 and 0…
1 means numeric
0 means not