>What setup is required in SQL Server to have a SQL result which will include all French characters no matter how the query was entered?
>
>For example, if the user types ERIQUE as the string, I would like to obtain all the records having ERIQUE, ÉRIQUE, etc. in the result.
I'm using SQL Anywhere but you will want to check out "Collation Sequences" in the documentation, after you set a Code Page for the database you should be able to set a Collation Sequence to tell the server how to sort and compare strings...
-- Dave
--
David Mann
Software Developer
"I don't believe in 'isms', I just believe in me" -- Ferris Bueller