Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR 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%' ; 
 
PREVIOUS NEXT
Tagged: #case #insensitive #sql
ADD COMMENT
Topic
Name
8+5 =