Answers for "where value is not sql"

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 in sql server

select * from TableName(nolock) where onlineUser!=('Y')

Posted by: Guest on January-29-2021

Code answers related to "where value is not sql"