Re: Is it possible to return the no. of records found

In article <3472E34E.35D07215_at_benau.dk>, Casper Thrane <ct_at_benau.dk> writes
>Hi
>
>Is it possible to return the number of records a query found, instead of
>the actaul recordset?

Rather than use COUNT(*) which will read all the columns associated with the table use a constant i.e. COUNT(1) this performs the same function but is a lot easier on the internals since it does not have to go and search for all the columns. It's quicker too.

-- 
Neil Catton