/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 vote181 views1 answer
Less mysql display
SQL
0 vote178 views1 answer
Nvl2 syntax
SQL
0 vote190 views1 answer
How to map sql column to custom names
SQL
0 vote199 views1 answer
Select the date 30 days less that the todays date sql request
SQL
1 vote163 views1 answer
Psql datetime grather than
SQL
0 vote167 views2 answers
Postgres default user
SQL
16 votes166 views1 answer
Sqlserver add column to table
SQL
10 votes163 views5 answers
Mysql create user
SQL
1 vote169 views1 answer
Join first name and last name sql
SQL
0 vote170 views1 answer
Resullt all update knex mysql
SQL