Answers for "sql where value 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

Posted by: Guest on July-26-2021

is not numeric sql

SELECT ISNUMERIC(250) AS Result;

Posted by: Guest on September-13-2020

Code answers related to "sql where value is not number"