/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 vote183 views1 answer
Mysql search like but first exact match
SQL
0 vote145 views1 answer
Alter session set nls_language french
SQL
11 votes180 views1 answer
Creating tables in sql with python
SQL
0 vote165 views6 answers
Unique key in sql
SQL
0 vote168 views1 answer
How to check replication lag in mySQL
SQL
2 votes192 views2 answers
Create temporary table in mysql
SQL
0 vote185 views1 answer
How to find columns with null values in sql
SQL
29 votes174 views5 answers
Mysql show table structure
SQL
0 vote173 views1 answer
Show database not empty tables postgres
SQL
0 vote160 views1 answer
Limiting query result using where in sql
SQL