>
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.
If it's not broken, fix it until it is.
My Blog