You may be able to avoid explicitly using UPPER or LOWER by setting your
NLS_SORT to generic baseletter. Under the covers, however, that will
have the same effect as using UPPER and LOWER in that regular indexes on
the columns cannot be used.

If the concern is primarily with the performance implications of using
UPPER or LOWER, you can create a function-based index on UPPER(<<column
name>>). Before function-based indexes were available, it was also
common to create a shadow column that held a copy of the data in all
upper case and use that in your query.

Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC

-----Original Message-----
From: McGowan Annamarie
[mailto:oracledba-ezmlmshield-x79117399.[Email address protected]
Sent: Wednesday, November 02, 2005 9:14 AM
To: LazyDBA Discussion
Subject: Igore case on Select

What is the best way to have Oracle ignore case on an input field when
using a select....is there a way without using upper or lower??


Annamarie McGowan
FISC DC-MMK
603-791-7579
annamarie.[Email address protected]





--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page