/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 vote371 views1 answer
Oracle tablespace autoextend
SQL
0 vote368 views1 answer
Mysql aspas simples
SQL
1 vote374 views1 answer
What is a Database?
SQL
0 vote359 views1 answer
No suitable driver found for sqlite
SQL
1 vote374 views2 answers
How to check if sql query is correct online
SQL
3 votes365 views2 answers
Oracle apex charging debug
SQL
0 vote351 views1 answer
Character count sql
SQL
17 votes373 views6 answers
Current date in sql
SQL
7 votes352 views3 answers
How to check table name in current database sql
SQL
0 vote407 views1 answer
Sql find gaps in date ranges
SQL

Share