I should have been a bit more specific. "TextField" isn't a text datatype,
it's a varchar datatype, max 50 chars.

On the non-clustered index bit - it *has* helped, tremendously, in other
aspects of the stuff I've been working on. Just not *here*.

I agree, doing the "IN" and a nested SELECT isn't doing the trick. I'm
trying different query syntax to get rid of the sub-query, but haven't hit
on the right combo yet.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to