We are in the process of converting VFP 6 application to run with an Oracle back-end.

We have solved a number of issues but have run into a brick wall with checking for duplicate record. It looks like Oracle is case sensitve.

We have put a Primary Key on our table.

For Example:
Table: ChargeCodes
Primary Key: ChargeCategory Char(4)
ChargeCode Char(8)

In the VFP world we would build the following index
INDEX ON Upper(ChargeCategory + ChrageCode) ...

Any thoughts on how to setup a Primary Key in Oracle that is case insensitive?

Help is greatly appreciated.

Vince