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

1 vote222 views2 answers
Mysql update table from another table
SQL
0 vote328 views2 answers
Sqlalchemy default value for column
SQL
57 votes349 views6 answers
Sql alter table
SQL
0 vote230 views2 answers
Mysql disable foreign key checks
SQL
8 votes234 views2 answers
Oracle auto increment primary key
SQL
0 vote228 views1 answer
Tsql default value when no value returned by query
SQL
0 vote262 views1 answer
Tsql find the value and count of the item that occurs the most in a column
SQL
8 votes244 views3 answers
Oracle auto_increment
SQL
9 votes222 views2 answers
Oracle all tables in schema
SQL
10 votes250 views2 answers
SQL rounding numbers
SQL