/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

1 vote61 views1 answer
Flask-sqlalchemy filter_by contains
SQL
0 vote95 views3 answers
Sql count condition
SQL
0 vote99 views1 answer
Postgre admin slow
SQL
0 vote142 views1 answer
Show mysql account privilleges
SQL
2 votes106 views1 answer
Copy all values of a column to another column in sql in same table
SQL
1 vote99 views1 answer
Setval pgsql
SQL
0 vote116 views3 answers
Mysql regex replace
SQL
0 vote127 views1 answer
How to to get time in sql
SQL
0 vote120 views1 answer
Connect to ssms with python
SQL
0 vote128 views1 answer
Mysql join only one column
SQL

Share