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

3 votes350 views1 answer
Ms sql skip take
SQL
0 vote345 views1 answer
SQL > Manipulação de Tabelas > Constraint
SQL
1 vote335 views2 answers
Mysql update table from another table
SQL
1 vote353 views1 answer
Mysql select update same table
SQL
0 vote346 views1 answer
Recover deleted data from mysql database
SQL
0 vote438 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Tabl
SQL
2 votes369 views1 answer
Set auto increment from 1
SQL
0 vote379 views1 answer
Get the Domain Name, Page Name and Query Parameter from a URL
SQL
1 vote401 views1 answer
Isnull sql server
SQL
0 vote328 views1 answer
Mysql select distinct date from timestamp
SQL