/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

31 votes150 views4 answers
How to get duplicate records with multiple field in sql
SQL
0 vote140 views1 answer
Top 3 salary in sql
SQL
1 vote154 views2 answers
Limit sqlserver
SQL
6 votes133 views6 answers
Count mysql
SQL
0 vote146 views1 answer
Sql server separar numeros por comas miles
SQL
2 votes152 views1 answer
Oracle drop sequence if exists
SQL
0 vote138 views1 answer
Sqlite select split string
SQL
-1 vote151 views1 answer
Adding a new table psql
SQL
0 vote157 views1 answer
Mysql get only the field names in a table
SQL
28 votes136 views4 answers
Delete database mysql
SQL