Case insensitive 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 vote186 views1 answer
Postgresql subquery
SQL
0 vote197 views2 answers
Show slave status mysql
SQL
0 vote206 views1 answer
How to reset table in sql server
SQL
36 votes264 views6 answers
Change column data type sql
SQL
0 vote211 views1 answer
Azure sql server check foreign key
SQL
22 votes193 views6 answers
Create sql table
SQL
2 votes242 views1 answer
Oracle find constraints referencing a table
SQL
5 votes260 views1 answer
Oracle source query
SQL
2 votes191 views1 answer
Date_format for time sql
SQL
9 votes216 views2 answers
Nosql databases
SQL