unique case-insensitive SQL problem

Hello all,
Very odd set of circumstances, I'm creating a simple case-insensitive search engine for a site and a simplified query is as follows:

SELECT web_article.sec_id
FROM web_article
WHERE art_desc LIKE '%search_term%'

We are using Oracle and I know you can make Oracle case-insensitive using the upper function so I could just do the following:

SELECT web_article.sec_id
FROM web_article
WHERE UPPER(art_desc) LIKE UPPER('%search_term%')

Here's my problem. Although I am using Oracle, due to some issues with how we connect to the database we can not use Oracle specific functions. So I guess I would have to find a way to do this in standard SQL. The problem is that SQL by itself is case-insensitive so I strongly doubt there is anyway to handle this.

Can anyone please help to prove me wrong?

Upper is a standard sql function.

A comparison in SQL is not case-insensitive by default. It depends on which collation you are using.

i feel like an idiot, my original post had the answer in it, i was just testing it totally wrong....

i'm not going to even get into it...

thanks.