/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 vote124 views2 answers
Sql max count
SQL
0 vote100 views1 answer
Mysql select where text contains
SQL
8 votes121 views1 answer
Database backup in mysql server recovery
SQL
0 vote123 views1 answer
Sql query to get column names and data types in sql server
SQL
4 votes108 views1 answer
Oracle select first 10 rows
SQL
3 votes157 views1 answer
Apex call duration
SQL
17 votes109 views6 answers
Change column name in sql
SQL
0 vote118 views1 answer
View psql output in horizontal scrolling
SQL
0 vote105 views1 answer
Get number of rows in every table mysql
SQL
0 vote95 views1 answer
Knex last insert id mysql
SQL