Sql is not like

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

Similar codes

0 vote164 views1 answer
Copy from one table to another postgres using matching column
SQL
1 vote131 views1 answer
Oracle grant on all tables in schema
SQL
0 vote90 views1 answer
Connection error in mysql workbench
SQL
0 vote126 views2 answers
How to find sql server agent jobs related to a database
SQL
3 votes125 views3 answers
Mysql select table names
SQL
0 vote164 views3 answers
Characters found after end of sql statement
SQL
0 vote121 views1 answer
Pgsql is not permitted to log in
SQL
8 votes131 views1 answer
Declare table variable sql server
SQL
0 vote157 views1 answer
Call function sql oracle with output put line
SQL
0 vote139 views1 answer
FIND LOWEST SALARY EARNER IN SQL
SQL