>Hello,
> 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.
>
>Thanks,
>
>TFISHER
It depends what functions supported by back-end. For example, SQL-Server supports SOUNDEX() and it can be used, but for other back-ends it might not be true.
Edward Pikman
Independent Consultant