/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

4 votes228 views3 answers
Oracle sql first day of quarter
SQL
0 vote230 views1 answer
How convert into in in sql query
SQL
0 vote227 views3 answers
Average salary in sql
SQL
0 vote243 views2 answers
What is rownum in oracle
SQL
0 vote223 views1 answer
Sql server alter table add column datetime default current_timestamp
SQL
0 vote240 views1 answer
Mysql change innodb to myisam
SQL
2 votes219 views3 answers
3 days back in sql server
SQL
3 votes224 views2 answers
How to start mysql in terminal
SQL
0 vote242 views1 answer
Sqlite trim
SQL
0 vote241 views1 answer
Mysql last friday of current month
SQL

Share