Check Numeric Value in Column of Table in MS SQL
Imagine that we want to check numeric value entered in any column of table,then for fetching numeric value from column which contain alphabets and numeric value in it.Then we have to use ISNUMERIC() function.
This function will return 0 for non-numeric value and 1 for numeric value.
Syntax for above condition as below:
SELECT columnname FROM tablename WHERE
ISNUMERIC(columnname) = 1;
Consider that we have employee table with column Emp_id,Emp_name,Salary,City and Phone.
Now we can find out employee name which contain only numeric value in their name by the following query.
SELECT Emp_Name FROM employee WHERE
ISNUMERIC(Emp_Name) = 1;
The above query will display only those employee name which contain numeric value in their name.
I hope this article will help you.