/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 vote138 views1 answer
Change date format in oracle query
SQL
5 votes135 views6 answers
Sql add days to date
SQL
0 vote132 views1 answer
How to reset AI in sql
SQL
4 votes177 views1 answer
Fatal error: libpq-fe.h: No such file or directory
SQL
5 votes155 views1 answer
Oracle sysdate - 1 month
SQL
0 vote153 views1 answer
Show table structure mysql console
SQL
8 votes132 views2 answers
Select table column name in sql
SQL
2 votes133 views2 answers
Mysql all columns
SQL
0 vote129 views1 answer
Django how to get query result count
SQL
0 vote134 views1 answer
Use where instead of join
SQL