Searching with Accent Marks

A client recently complained that when they perform a search on a name with accent marks, they cannot fnd it unless they search using the accent mark. Since they don't always know which name has an accent, this has been a problem. Is there an easy way to allow the search function to ignore teh accent marks that are in the database for the purpose of easier retrieval? Make sense?

Thanks,

Brian

What database? Basically you would remove that from the search and create a column based on that result.... something like:

REPLACE(ColumnName,'''','')

Would give you the column without quotes.. so you could create a query or view with that in your SQL statment like:

SELECT *, REPLACE(ColumnName,'''','') AS ColumnWithoutQuotes FROM TableName

Then you can use that query for your serch which would include that new column without quotes you could search on.