Skip to Content
0
Former Member
Jun 09, 2004 at 09:06 PM

Case-insensitive searches in Open SQL?

17 Views

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