Terry,
If the backend doesn't support a soundex() function it can be easily written in the backend. The algorithm for it isn't all that complicated.
> I would like to search a table for names using a remote view. When I search for "Smith", I would like to be able to get "Smithe" or "Smythe" as part of the result. Can you do this with SQL. SOUNDEX() is the command I have used on local tables.