/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 vote297 views1 answer
Learn sqlite dart
SQL
0 vote333 views1 answer
LoadError: cannot load such file -- mysql2/2.7/mysql2
SQL
3 votes303 views2 answers
Mysql create database
SQL
0 vote305 views1 answer
Mariadb errno 121
SQL
0 vote295 views1 answer
Check if table exists oracle
SQL
2 votes309 views1 answer
Mysql sysdate - 1 day
SQL
2 votes302 views4 answers
Duplicate record mysql
SQL
0 vote306 views1 answer
Postgres set default schema
SQL
40 votes393 views4 answers
PostgreSQL add column
SQL
16 votes320 views3 answers
Update table from another table
SQL

Share