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.
Describe table should also help u to know datatype
sir there is another operator which you can do same thing is REGEXP ‘[0-9]’.
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