Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to ignore Accent using oracle select query

user594543Sep 12 2007 — edited Sep 12 2007
want this select query using oracle 10g:

SELECT * FROM client
WHERE NLS_UPPER(name) LIKE '%ANDRE%'

to retrieve all names like:

Andre
Andréa
Andrêu
Ändre

not able to retrieve the data.. can anybody help on this..
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 10 2007
Added on Sep 12 2007
5 comments
2,979 views