/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 vote280 views1 answer
How to get table current identity value in sql server
SQL
1 vote277 views1 answer
Mysql pretty date format
SQL
0 vote294 views1 answer
Start stop mysql linux
SQL
0 vote281 views1 answer
Export partttion and import in oracle
SQL
1 vote287 views1 answer
Decalre temp table sql
SQL
1 vote274 views1 answer
How to select random rows from table
SQL
4 votes302 views1 answer
Conda install sqlalchemy
SQL
3 votes290 views1 answer
Stpop start psql server
SQL
5 votes285 views1 answer
Postgres integer to serial
SQL
0 vote315 views1 answer
Insert using condition postgres
SQL

Share