/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 vote178 views1 answer
Oracle enable chain
SQL
0 vote172 views1 answer
Joins vs includes
SQL
103 votes2.4K views1 answer
Like sql
SQL
1 vote163 views1 answer
Sql delete all values in a column
SQL
7 votes167 views2 answers
Mysql db size
SQL
1 vote164 views1 answer
How to change owner in postgres
SQL
0 vote163 views1 answer
Select all tables linked server sql
SQL
0 vote165 views1 answer
Delete double on SQL with multiple primary keys
SQL
2 votes188 views1 answer
Import large .sql files into lampp
SQL
0 vote176 views1 answer
Mysql date time string format for marshmellow field schema
SQL