There is no parameter that can do that, but you can use
SELECT lastname FROM personnel WHERE UPPER(department)
LIKE 'D%'
HTH
Venkat
> I have Oracle8 for NT. Does anyone know of a configuration parameter
>that would make the database case insensitive as far as SQL statements
>are concerned? For example:
>
> select lastname
> from personnel
> where department like 'd%'
>
> select lastname
> from personnel
> where department like 'D%'
>
>I would like both of these queries to return any department that starts
>with the letter d regardless of case. Thanks in advance for the help.
Received on Thu Apr 09 1998 - 17:37:26 CDT
