| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Case Sensitivity in select
Sure,
Use UPPER or LOWER Function like :
UPPER(Field)='HELLO' or LOWER(Field)='hello'
Both retrieve HELLO, HEllo, Hello, HeLlO, .....
JY ANDRE Stu wrote:
> Is it possible to set a parameter which will make a select statement
> case insensitive. i.e. so that select * from words where word='hello'
> will bring back records where word='HELLO' or 'Hello'.
Received on Thu Aug 26 1999 - 06:49:53 CDT
 |
 |