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 vote190 views1 answer
Mysql query single row
SQL
0 vote190 views1 answer
NLS_NCHAR_CHARACTERSET
SQL
5 votes177 views2 answers
Create table
SQL
0 vote195 views1 answer
Sql server datetime to string
SQL
1 vote189 views1 answer
Type int in mysql maxlenght
SQL
1 vote215 views2 answers
Postgresql check privileges on schema
SQL
0 vote198 views1 answer
Psql select * from table
SQL
1 vote199 views1 answer
Mysql show queries running
SQL
1 vote192 views1 answer
Find a column in all tables postgres
SQL
0 vote190 views1 answer
Drop all procedures sql server
SQL