/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 vote374 views1 answer
Change permission to database mysql
SQL
7 votes387 views2 answers
How to create index mysql
SQL
0 vote368 views1 answer
Postgresql list extensions
SQL
5 votes336 views2 answers
Oracle rename table
SQL
1 vote353 views1 answer
Sql server list locks
SQL
2 votes325 views2 answers
Join update query in sql
SQL
1 vote346 views1 answer
Alter add syntax
SQL
-1 vote304 views1 answer
How to format tables in sqlplus
SQL
0 vote370 views1 answer
Declare or use variable in snowflake
SQL
0 vote335 views1 answer
Check if database exists sql
SQL