Structure language query numeric function

Data Science, AI and ML
#1

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

#2

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
#3

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

2 Likes
#4

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

1 Like
#5

Great sagar keep sharing ur knowledge

#6

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