/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 vote141 views1 answer
Mysql add root password
SQL
0 vote133 views1 answer
Mysql create index lost connection
SQL
-1 vote131 views3 answers
How to restart mysql in linux
SQL
1 vote142 views1 answer
Psql import backup file for windows
SQL
2 votes141 views1 answer
Create delete procedure mysql
SQL
2 votes165 views3 answers
How to replace null values in sql
SQL
0 vote126 views1 answer
Uninstall mysql ubuntu 18.04 stackoverflow
SQL
0 vote182 views1 answer
Regex mongoose
SQL
0 vote142 views1 answer
Postgresql log
SQL
0 vote135 views1 answer
Sql drop procedure if exists
SQL

Share