/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 vote220 views1 answer
Sql create table with datetime automatically
SQL
0 vote233 views1 answer
My sql data file extention
SQL
0 vote222 views1 answer
Sql include rows with 0 values
SQL
0 vote225 views1 answer
Postgresql if else endif
SQL
0 vote219 views1 answer
Show table structure mysql console
SQL
8 votes245 views1 answer
Oracle alter tablespace add datafile autoextend max size
SQL
2 votes230 views1 answer
Get first n letter of department name in sql
SQL
1 vote232 views2 answers
Mysql update LAST_INSERT_ID()
SQL
0 vote253 views1 answer
Implode in sql query
SQL
45 votes254 views5 answers
Grant all privileges mysql
SQL