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 vote276 views1 answer
Postgresql get diff between two dates in Months
SQL
24 votes255 views4 answers
Mssql get all table names
SQL
0 vote251 views2 answers
Postgresql get long running queries
SQL
2 votes282 views1 answer
Mysql shell insert into
SQL
1 vote263 views1 answer
Sql where last 12 months
SQL
2 votes292 views1 answer
Pdo mysql insert
SQL
0 vote266 views1 answer
Sql anywhere create procedure
SQL
1 vote275 views1 answer
Too many connections mysql
SQL
0 vote267 views1 answer
Alter owner in PostgreSQL
SQL
0 vote274 views1 answer
How to query without duplicate rows in sql
SQL