/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 vote296 views1 answer
SQL Query Orderby Two or More Columns and by number of characters
SQL
0 vote314 views1 answer
Oracle list of long running queries
SQL
2 votes368 views1 answer
Tcl in sql
SQL
1 vote296 views2 answers
Populate sql table with random data
SQL
21 votes310 views4 answers
Oracle add column
SQL
0 vote358 views1 answer
Get initial in sql
SQL
0 vote297 views1 answer
Convert rows into columns in oracle
SQL
0 vote317 views1 answer
Mysql error 1251
SQL
1 vote324 views1 answer
Hackerrank sql test solutions
SQL
1 vote332 views1 answer
Sql set auto increment back to 0
SQL