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 vote144 views1 answer
Sql row having max
SQL
4 votes139 views1 answer
Mysql ip address data type
SQL
0 vote126 views1 answer
Connecting to my cloud sql server with c#
SQL
0 vote166 views1 answer
Postgresql concat string with separator
SQL
0 vote135 views2 answers
Postgres show current role
SQL
1 vote197 views2 answers
Sql server find all foreign keys that reference a column
SQL
8 votes146 views2 answers
Change name of colum in sql table
SQL
3 votes155 views2 answers
Synonym oracle
SQL
1 vote145 views1 answer
Alter constraint in sql
SQL
0 vote121 views1 answer
Trim sql oracle
SQL