/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

2 votes283 views1 answer
Oracle drop sequence if exists
SQL
6 votes289 views3 answers
Update with inner join postgres
SQL
0 vote306 views1 answer
How do I insert a blob in SQL?
SQL
0 vote453 views1 answer
Sql change a colum to unique
SQL
8 votes269 views2 answers
Mysql query dates between two dates
SQL
0 vote282 views1 answer
Interview experience as a call?
SQL
-1 vote275 views1 answer
Add bool column in sql
SQL
9 votes265 views2 answers
Oracle all tables in schema
SQL
1 vote301 views3 answers
Sql union
SQL
0 vote495 views1 answer
The SELECT permission has not been granted on 'sys.sql_logins' for the 'master' database. You must be a member of the 'loginmanager' role to access this system view.
SQL