/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 vote305 views1 answer
Https://www.jitendrazaa.com/blog/sql/sqlserver/export-documents-saved-as-blob-binary-from-sql-server/
SQL
13 votes290 views3 answers
Sql online code
SQL
6 votes343 views3 answers
Psql show columns of table
SQL
0 vote314 views1 answer
Logtash mysql cofiguration file
SQL
0 vote378 views1 answer
How to check foreign key constraint in sql
SQL
0 vote298 views1 answer
Oracle allow space to user
SQL
0 vote287 views1 answer
Mysql show foreign keys column
SQL
1 vote341 views1 answer
Oracle create program if not exists
SQL
0 vote287 views1 answer
Select row from mysql where date more than 30 days
SQL
0 vote315 views1 answer
Sql query tags
SQL

Share