>>>

select FirstName, LastName, Address, City, State, Zip
>>>     from Customers where state= 'NY' and city like '%ISLAND%'  AND ADDRESS LIKE '%BLVD%'

>>>
>>>Yeah, that's optimizer-friendly. But how are you going to generate it in your SP?! That looks more like SPT to me.
>>
>>Is LIKE %Something% optimizable??? I thought only LIKE 'Something%' optimizable.
>
>Yes, through an index scan.. and index scan is something VFP does not have. It scans the index file for anything that matches the LIKE expression. It is more effective than a table scan, but less effective than an index seek.

Thanks, Walter.