/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 vote139 views1 answer
Enable outgoing remote MySQL access
SQL
0 vote142 views2 answers
Postgresql gset
SQL
0 vote140 views1 answer
Test the postgresql db connection
SQL
0 vote137 views1 answer
Groupby error in mysql
SQL
1 vote385 views1 answer
Sequence item 6 expected str instance bytes found mysql workbench
SQL
0 vote140 views1 answer
Write a query to peint the pattern P(20)
SQL
0 vote147 views1 answer
Sparql list all graphs
SQL
0 vote153 views1 answer
SQL Error 1040 : Too many connections
SQL
37 votes151 views5 answers
FIND DUPLICATES IN COLUMN SQL
SQL
8 votes200 views2 answers
Oracle auto increment primary key
SQL

Share