/SQL/How to make case insensitive in sql

How to make case insensitive in sql

-- find everyone with  first_name contains d case insensitive manner
Make everthing either lower or upper case

SELECT FIRST_NAME , LAST_NAME 
FROM EMPLOYEES 
WHERE LOWER(FIRST_NAME) LIKE '%d%' ;

Similar codes

0 vote350 views1 answer
Narural join
SQL
1 vote345 views1 answer
Pentaho + pasar de excel a sql
SQL
8 votes373 views3 answers
Postgres connection string
SQL
1 vote381 views2 answers
Grab part of a string sql
SQL
7 votes367 views3 answers
Python and mysql connectivity
SQL
0 vote339 views1 answer
A network or instance-specific error sql server
SQL
0 vote351 views1 answer
Mysql cast null to string
SQL
0 vote324 views1 answer
Sqlalchemy.exc.DBAPIError: (ibm_db_dbi.Error) ibm_db_dbi::Error: SystemError('<built-in function connect> returned NULL without setting an error')
SQL
0 vote331 views1 answer
Tsql cmd exec script from file
SQL
0 vote372 views1 answer
Show all sequences postgres
SQL