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 vote146 views1 answer
Mysql view curren querys
SQL
8 votes158 views1 answer
Mysql restore database
SQL
1 vote144 views1 answer
Oracle grant on all tables in schema
SQL
0 vote139 views1 answer
Sql recherche nom prenom
SQL
20 votes147 views1 answer
Sql change column types
SQL
0 vote131 views1 answer
Sql clear table
SQL
1 vote142 views1 answer
Psql filed name alter
SQL
0 vote156 views1 answer
Format the money fied with comma in international system using sql
SQL
1 vote137 views1 answer
Create procedure with encryption
SQL
3 votes275 views6 answers
Sql unique select
SQL