>>>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
You may include Expression to the list of seleted fields or to filter condition list. This expression will include SOUNDEX(TRemotetable.FieldX).
Edward Pikman
Independent Consultant