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

5 votes369 views2 answers
Mysqldump password
SQL
0 vote373 views1 answer
T-sql update table variale
SQL
0 vote336 views1 answer
Where in clause tsql
SQL
3 votes355 views2 answers
Enter mysql command line
SQL
1 vote336 views1 answer
Convert rows to string sql server
SQL
0 vote364 views1 answer
How to find total working hour in sql
SQL
0 vote353 views1 answer
Postgresql combine values in one field
SQL
0 vote325 views1 answer
Is not null postgresql
SQL
0 vote351 views2 answers
Create sequence if not exists postgres
SQL
0 vote345 views1 answer
Mysqldump ignore table
SQL