Oracle UPPER with the SQL LIKE

Question

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.

Answer 1

SELECT *
FROM Table
WHERE UPPER(column) LIKE UPPER('%test%')

Did you try something like this?

Answer 2

nope let me try