BackOrder NOT LIKE '%HR%'  could be causing you problems even if that field
is indexed, because you're not looking at the beginning of the field. Is
there anothere way of doing it?

For the title fields also, have you considered full text indexing?

Nick
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Click Here

Reply via email to