Case-insensitive searches in Open SQL?

[Former Member]

Dear Open SQL experts,

How can I scan a table using Open SQL syntax to find case-insensitive matches?

In Oracle the query a user would use to find all materials that have word "Gear" in them would look like:

SELECT mat_id, mat_desc, mat_status, mat_model FROM mat

WHERE LOWER(mat_desc) LIKE '%gear%'

Thanks a lot you for your help!

Regards,

-Yuri

[Private_Member_14935]

Hi,

How did you resolve this issue? Any hints on addressing this will be appreciated.

The solutions we have considered include - search table approach where we maintain the id and value upon which the search needs to be performed in CAPS, and 2ndly compare the value with possible combinations.

Regards,

Ria