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