>

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.