not in ms sql query code example
Example 1: sql not
Returns true if a record DOESN’T meet the condition.
Example: Returns true if the user’s first_name doesn’t end with ‘son’.
SELECT * FROM users
WHERE first_name NOT LIKE '%son';
Example 2: is not in sql server
select * from TableName(nolock) where onlineUser!=('Y')