Sql

SELECT ISNUMERIC(250) AS Result;

select * from tab
where AddressLine1 not like '%[0-9]%'

SELECT CustomerId FROM CUSTOMER_TABLE 
WHERE CustomerId ISNUMERIC(CustomerId) = 0

-- if you want to get only number try to change 0 to 1

PREVIOUS	NEXT

Code Example
Sql :: sql or
Sql :: create a table in sql
Sql :: pl sql create function
Sql :: minus equivalent in my sql
Sql :: UNION ALL LEFT JOIN
Sql :: how to find first 3 highest salary in sql
Sql :: sql rename column in select
Sql :: carbon mysql d m y to y-m-d
Sql :: TRIGGER AFTER
Sql :: connect to mysql server mac terminal
Sql :: sum row in sql
Sql :: sql select rows with simlar names
Sql :: procedure syntax
Sql :: case vhdl
Sql :: Postgres format number to 2 decimal places
Sql :: tsql generate rows
Sql :: mysql update from n to 100
Sql :: mysql pass command from command line
Sql :: oracle all columns
Sql :: SQL Syntax of FULL OUTER JOIN
Sql :: mysql join column order By and group By
Sql :: sql server inner join
Sql :: sql average
Sql :: three inner joins sql
Sql :: SQL CREATE INDEX Constraint
Sql :: reset postgresql password windows
Sql :: postgres disable foreign keys
Sql :: local pg_sql to heroku pg_sql
Sql :: group by
Sql :: sql delete dastabase