Answers for "sql string contains case sensitive"

SQL
1

sql like case sensitive

-- Postgresql case insensitive:
SELECT * FROM people WHERE name ILIKE 'JOHN'
-- John
-- JOHN
-- john
Posted by: Guest on April-05-2021
0

sql string contains case sensitive

SELECT DISTINCT COL_NAME FROM myTable WHERE UPPER(COL_NAME) LIKE UPPER('%PriceOrder%')
# or
SELECT DISTINCT COL_NAME FROM myTable WHERE LOWER(COL_NAME) LIKE LOWER('%PriceOrder%')
Posted by: Guest on July-14-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language