RM> we have a query which goes to 7kb...
"7 kb"? I don't mean to be picky, but do you mean "seven kilo-bytes"? I'm
thinking that either you mean some much larger number, or that I'm missing
something terribly.
Either way, what does your query look like? Are you joining across 3 tables and
then back onto one of those tables again, and then using a bunch of LIKEs and
ORs? Or is this just a simple "select * from xyz"?
If it isn't obvious from your query as to what's the problems, then we should
probably know a bit about your server config. Like, "We're running on Win3.11".
;-)
----
Rodney Broom