remove characters from search criteria

[navee]

Hi, I am writing a search functionality to search the database field. I have to
eliminate umlauts( non-consonants) from the search text before comparing with
database. How can I eliminate these characters? Thanks..

[zoeski80]

Hi Navee

Don't think there are any built-in functions to allow you to do this.
I'd probably make a list of all the ASCII characters for these umlaut
characters and loop over them doing a ReplaceNoCase on your string.
Don't know much about umlauts but this could take a while if the list of
umlauts is quite long.

Zoe