Posted by strawberry on 05/22/06 19:24

You miss my point. I DO want ALL the columns. It's just that (from what
I've read) the query is supposed to work faster if ALL the columns are
individually named in the query.

So, if that's true - and with that fact in mind - is the code I've
written the simplest way of going about this or is there (as I'm sure
there must be) a better way?

For instance, one of my queries requests some 100 or so fields from a
contacts database of 1000 or so records. I rather like the idea of
rewriting the query somewhat like that shown above - if it really is
the case that doing so will considerably increase the speed at which
the query executes.

[Back to original message]