Answers for "SQL case when contains"

SQL
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