/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

1 vote182 views1 answer
Date_part mysql
SQL
0 vote176 views1 answer
Update top 100 sql
SQL
5 votes219 views2 answers
Functions
SQL
0 vote182 views1 answer
Copying query result to excel
SQL
1 vote175 views1 answer
Drush sql-dump
SQL
0 vote189 views1 answer
Copied text from internet not inserting in mysql
SQL
0 vote193 views1 answer
Cube oracle
SQL
0 vote196 views1 answer
Function sum(text) does not exist postgres
SQL
0 vote170 views1 answer
Oracle tablespace autoextend
SQL
0 vote178 views1 answer
Optimize sql query
SQL