not like query in sql

like sql

WHERE CustomerName LIKE 'a%'	
--Finds any values that start with "a"
WHERE CustomerName LIKE '%a'	
--Finds any values that end with "a"
WHERE CustomerName LIKE '%or%'	
--Finds any values that have "or" in any position
WHERE CustomerName LIKE '_r%'	
--Finds any values that have "r" in the second position
WHERE CustomerName LIKE 'a__%'	
--Finds any values that start with "a" and are at least 3 characters in length
WHERE ContactName LIKE 'a%o'	
--Finds any values that start with "a" and ends with "o"

Posted by: Guest on November-14-2019

SELECT * FROM emp WHERE name NOT LIKE 'a%' -- not starting with a AND name NOT LIKE '%a' -- not ending with a AND name NOT LIKE '%a%' -- not containing a AND upper(name) NOT LIKE '%A%' -- not containing a or A

Code answers related to "not like query in sql"

Browse Popular Code Answers by Language

Answers for "not like query in sql"

Code answers related to "not like query in sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us