case insensitive select

[Odd Bjørn Andersen]

Is there a way to achieve that a select against a database will be case
insensitive?

Meaning that 'select ' from tab1 where col1 = 'abc'' will return the same
result as 'select ' from tab1 where col1 = 'ABC'' . I know the functions
UCASE and LCASE (and TRANSLATE), but this is not what I'm after now. I am
looking for some kind of parameter (on the client or the database server)
that will achieve this.

I'm told that this is possible on both Oracle and Sql Server. But what
about db2?

Regards
Odd B Andersen
ErgoGroup AS

[Serge Rielau]

Odd Bjørn Andersen wrote:

Is there a way to achieve that a select against a database will be case
insensitive?

Meaning that 'select ' from tab1 where col1 = 'abc'' will return the same
result as 'select ' from tab1 where col1 = 'ABC'' . I know the functions
UCASE and LCASE (and TRANSLATE), but this is not what I'm after now. I am
looking for some kind of parameter (on the client or the database server)
that will achieve this.

I'm told that this is possible on both Oracle and Sql Server. But what
about db2?

There is no database wide parameter. You can handle case insensitivity
per column using GENERATED columns.
If you want teh whoel database to be case insensitive, why not just
normalize the data to all upper or lower caps?

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
DB2 UDB for Linux, Unix, Windows
IBM Toronto Lab