>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?
I can remove it for the time being. Later create a bit column for HR.
>For the title fields also, have you considered full text indexing?
Considering it now...
>Nick
>
>----------
>[
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
