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

2 votes131 views1 answer
Oracle sql drop column if exists
SQL
0 vote167 views1 answer
Mysql error codeigniter
SQL
1 vote266 views1 answer
Sql check roles
SQL
4 votes129 views1 answer
Sql delete multiple conditions
SQL
1 vote144 views1 answer
Full sql mode
SQL
0 vote127 views1 answer
Equi joins in oracle
SQL
103 votes337 views2 answers
Sql server LIKE '%%'
SQL
0 vote140 views2 answers
Sql searching via key word
SQL
0 vote147 views1 answer
Postgresql cast as year and month from timestamp
SQL
0 vote143 views1 answer
PGSQL dynamic table name
SQL