Case sensitive - search script

[Elknox]

I have a search script that takes a sting from a text box and searches an oracle 8 database. The Script works fine, but has one major problem, that of being case sensitive. I would like it to be case insensitive as the database records are of mixed case. Any help?

[rharter]

convert what you are searching for to upper and then use the oracle equivalent of the mysql upper function:

SELECT 'A' LIKE UPPER(col_name) FROM table_name;