Case insensitive selects

I think this has been on the NG recently, and I think I know the answer BUT ......

can somebody confirm that there is no instance parameter that can make a select statement case insensitive..

e.g select username from employees where username like 'smi%';

  to return SMITH, Smithers, sMithereens etc , etc.....

I know I can use upper() and lower() functions ...

Using Oracle8.0.5 on NT

Cheers

Steve Bright

steve.bright_at_capgemini.co.uk Received on Wed May 05 1999 - 05:16:54 CDT