Re: Dealing with case sensitivity

try: select * from employee where lastname like UPPER('HA%');

John Harris wrote:
>
> How does one handle case sensitivity with string searches using the LIKE
> operator?
> If I have something like: select * from employee where lastname LIKE "ha%"
> But I want to get all possibilities regardless of case sensitivity - harris,
> Harris HArris HARRIS haRRis...
>
> Is this possible with straight SQL against an Oracle database?
>
> John Harris
Received on Sun Jan 27 2002 - 00:32:39 CST