>>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.

Hello,

Thank-you for your quick response. I am currently using VFP tables, creating a view with the view designer. I am not sure how to incorporate SOUNDEX() into the SQL generated by the view designer.

Thanks,

TFISHER