Case Sensetive text Searches

[Shahine]

Hi.

Is there a way of creating an Oracle-9i database so that all Varchar2 type fields can be "case insensitive" for searches?

Instead of using Upper(fieldname) Like ...

Many Thanks
Shahine.

 

[Marco Kalter]

If you are using a TOracleDataSet in QBE mode to perform these searches, then you can set the "Case Insensitive" property of the QBE fields to search case insensitive. This will still use the Upper function though.

------------------
Marco Kalter
Allround Automations