Answers for "sql lowercase match"

SQL
2

uppercase and lowercase in sql

select UPPER('converted to upper');
select LOWER('CONVERTED TO LOWER');
Posted by: Guest on June-21-2020
0

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%' ;
Posted by: Guest on January-07-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language