Ignore capitalization in Oracle 8i?

What is the way to ignore capitalization when doing a query against Oracle? I know it can be done because we use a front end system (written in VB) that connects to an 8i back end has an option that allows you to ignore capitalization when doing a query. Which means there is a way to make Oracle ignore case, is it an SQL command? Is it a setting on the database itself?

I'm writing an application that has an Access 2000 front end and an 8i back end and the queries appear to be case sensitive.

Note: I previously posted this as "case sensitivity in a parameter query" but I didn't give enough information.

Thank you,
Mike Received on Sat Dec 15 2001 - 12:04:53 CET