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 vote166 views2 answers
Drop function in sql
SQL
0 vote190 views2 answers
Impala rename column name
SQL
0 vote188 views1 answer
Create table split string function in sql server
SQL
3 votes180 views1 answer
Sql calculate working days between two dates excluding weekends and holidays
SQL
0 vote163 views1 answer
Connexion mysql
SQL
1 vote183 views1 answer
Tsql replace value in json
SQL
0 vote176 views1 answer
How to read the potentail error messages in ssis package
SQL
0 vote160 views1 answer
Equi joins in oracle
SQL
0 vote174 views1 answer
Select sql in descending order
SQL
9 votes157 views3 answers
Show table columns mysql command line
SQL