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!