how to make case insensitive in sql 1

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%' ; 

Here is what the above code is Doing:
1. We are selecting the first_name and last_name columns from the employees table.
2. We are using the WHERE clause to filter the results.
3. We are using the LOWER function to convert the first_name column to lowercase.
4. We are using the LIKE operator to find all first_name values that contain the letter d.

Similar Posts