>Thanks for your help
>
>>(2) When using "$" in VFP, you can have
>> (a) MYFIELDNAME $ MYSTRING or
>> (b) MYSTRING $ MYFIELDNAME.
>> Can the the LIKE command in SQL Server achieve the same results as above ?
>
>You can but it could be slow on big tables.
>... MYFIELDNAME Like ('%' + MYSTRING + '%') Or
> MYSTRING Like ( '%' + MYFIELDNAME + '%')
>
>Is there a faster way to achieve the same result on big tables ? Is charindex faster.

It isn't slow because of LIKE operator but because every record in the table has to be processed.