you're right it wasn't the right plan. i must have executed a query
changed the sql and used the plan for the original query but copied
the changed sql into the post.

ok so like and containing don't use indexes which is where the
difference will be.

thanks

mark