Re: Oracle8 case sensitivity

From: Chris Hamilton <toneczar_at_erols.com>
Date: 10 Apr 1998 12:40:51 GMT
Message-ID: <01bd647d$e39dc860$73344b9b@chrish.hq.usace.army.mil>

Venkat <vreddy_at_ix.netcom.com> wrote ...

> There is no parameter that can do that, but you can use
> SELECT lastname FROM personnel
> WHERE UPPER(department) LIKE 'D%'

True, but be careful. By applying a function (UPPER) to the department column on the left-hand side of the WHERE clause, you disable the index on that column (for that query).

A better approach could be

select lastname
from personnel
where department like upper('D%');

Of course, you would need to know that all of your department data is in upper-case.

Chris

---

Chris Hamilton -- christopher.h.hamilton_at_usace.army.mil U.S. Army Corps of Engineers
http://www.serve.com/cowpb/chamilton.html Received on Fri Apr 10 1998 - 07:40:51 CDT