Searching with Accent Marks

[brian70185]

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

[Ray Borduin]

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.