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.