/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
Check duplicate values plsql
SQL
0 vote202 views1 answer
How to find sql server installation folder
SQL
11 votes209 views3 answers
Sql_mode=only_full_group_by
SQL
12 votes203 views4 answers
Mysql get date difference in hours
SQL
1 vote205 views2 answers
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.4.0 or newer is required; you have 0.10.1.
SQL
0 vote215 views1 answer
New rails app with mysql
SQL
8 votes206 views2 answers
Safe update mode in mysql
SQL
10 votes200 views2 answers
Show tables in schema oracle
SQL
0 vote200 views1 answer
Query params sql insert python f string
SQL
0 vote191 views1 answer
Call rest api from postgresql
SQL