Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Oracle8 case sensitivity
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.
Jim Received on Thu Apr 09 1998 - 14:25:56 CDT