/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 vote275 views1 answer
Convert epoch to date in sql server
SQL
2 votes263 views3 answers
Mysql list tables by size
SQL
0 vote298 views2 answers
Generate sql trigger through ef migration
SQL
9 votes255 views2 answers
Oracle all tables in schema
SQL
-1 vote271 views1 answer
Get id from just inserted row mysql server python
SQL
1 vote297 views1 answer
Mysql take number in string
SQL
0 vote215 views1 answer
Copy table dbeaver
SQL
0 vote275 views1 answer
Flexible search query delete table
SQL
5 votes283 views2 answers
Sql constraint check value in list
SQL
3 votes245 views4 answers
Show sql server database
SQL

Share