0

Oracle UPPER with the SQL LIKE

How to incorporate the Oracle UPPER function with the SQL LIKE condition? I'm trying to query against a free text field for all records containing the word "test". The problem is that it can be entered in the following ways: TEST, Test, or test.

16th Apr 2020, 7:19 AM
Isira Shamintha
Isira Shamintha - avatar
2 odpowiedzi
+ 1
SELECT * FROM Table WHERE UPPER(column) LIKE UPPER('%test%') Did you try something like this?
16th Apr 2020, 7:40 AM
Michal
Michal - avatar
0
nope let me try
16th Apr 2020, 8:14 AM
Isira Shamintha
Isira Shamintha - avatar