/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

13 votes184 views1 answer
Sql join 3 tables on id
SQL
7 votes182 views3 answers
Convert ansi sql
SQL
0 vote189 views1 answer
Default password for mysql_secure_installation in mac
SQL
0 vote180 views1 answer
How to add boolean column in postgresql
SQL
0 vote199 views2 answers
How to prevent sql injection in java
SQL
1 vote202 views2 answers
How to combine 2 tables in MySQL
SQL
1 vote191 views1 answer
Retrieve meaning
SQL
0 vote190 views1 answer
Helptext in sql
SQL
0 vote182 views1 answer
Sql server user permissions and roles
SQL
3 votes159 views1 answer
Mysql CURRENT_TIMESTAMP()
SQL