/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 vote115 views1 answer
Ms sql print more than 1 variable
SQL
1 vote115 views1 answer
Full text index mysql
SQL
0 vote299 views1 answer
Android sqlite add column if not exists
SQL
0 vote197 views1 answer
Sql get latest of 2 datetimes
SQL
3 votes163 views4 answers
Show sql server database
SQL
0 vote161 views1 answer
Sql server order by nulls last
SQL
4 votes170 views2 answers
Oracle default date format
SQL
0 vote195 views1 answer
Alter domain sql
SQL
1 vote181 views2 answers
Mysql trim spaces
SQL
0 vote166 views1 answer
Select last N rows mysql
SQL

Share