Folks, Is there a way to make Oracle use the index (funtion based) in a search query with wild card at both ends as in the following.
SELECT “NAME”, “DESCRIPTION” FROM MY_TABLE WHERE UPPER(“DESCRIPTION”) LIKE ‘%ABC%’