/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

5 votes184 views1 answer
Oracle get nls settings
SQL
0 vote174 views1 answer
Best way to bind parameters to SqlCommand C#
SQL
0 vote197 views1 answer
Wordpress delete post revisions older than date "sql"
SQL
3 votes176 views1 answer
Oracle rollback
SQL
0 vote188 views1 answer
Order by with where clause in mysql
SQL
5 votes223 views2 answers
Postgresql insert select
SQL
2 votes205 views1 answer
Removing view
SQL
2 votes255 views2 answers
Null column to 0 in mysql
SQL
0 vote173 views1 answer
Save single sql query result boolean spring boot
SQL
2 votes177 views2 answers
Mysql on duplicate key ignore
SQL