/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

8 votes92 views1 answer
Oracle current date plus 1 month
SQL
0 vote116 views1 answer
Create new table pl sql
SQL
0 vote132 views1 answer
Mysql pad zeros
SQL
1 vote127 views1 answer
Backup mysql data only
SQL
37 votes127 views5 answers
FIND DUPLICATES IN COLUMN SQL
SQL
0 vote134 views1 answer
Oracle procedure teamplate
SQL
2 votes130 views1 answer
Date conversion in mysql column
SQL
1 vote123 views1 answer
Found option without preceding group in config file: /etc/mysql/mariadb.conf.d/50-server.cnf at line: 1
SQL
3 votes124 views1 answer
Mysql set field unique
SQL
0 vote127 views1 answer
Bidirectional outer join sql
SQL

Share