/SQL/Sql where is not number

Sql where is not number

Sql where is not number

SELECT CustomerId FROM CUSTOMER_TABLE 
WHERE CustomerId ISNUMERIC(CustomerId) = 0

-- if you want to get only number try to change 0 to 1

1

Source: stackoverflow.com

Is not numeric sql

SELECT ISNUMERIC(250) AS Result;

0

Source: database.guide

Similar codes

0 vote305 views1 answer
Drop view in mysql
SQL
0 vote278 views2 answers
How to use aggregate functions in sql
SQL
3 votes309 views5 answers
No module named 'MySQLdb'
SQL
0 vote259 views1 answer
Mysql export data with a where clause
SQL
5 votes271 views1 answer
Oracle nls parameters
SQL
4 votes349 views1 answer
How to check last gather stats on table in oracle
SQL
2 votes323 views1 answer
Capitalize 1st letter in sql server
SQL
6 votes273 views4 answers
Delete table sqlite
SQL
0 vote268 views1 answer
How to select even id in sql
SQL
0 vote299 views1 answer
Sql ssrs
SQL

Share