NLS_UPPER and French characters

[Quoted] We are trying to implement a search on a column that contains french characters. The problem is that the é is stored as i and doing a search on both the é and the i both returns values, when we only want to return the é value.

We have tried using the nls_upper with the following sql

select * from table where nls_upper(column, 'NLS_SORT=French') like nls_upper('%é%', 'NLS_SORT=French')

Does anyone have any thoughts
Thanks in Advance
Shona
gingersnap133_at_hotmail.com Received on Wed Aug 14 2002 - 00:06:35 CEST