I need to know how many records are returned each time a particular SELECT query is run. I know that is I use a Static cursor, I can use the ADO Recordcount, but I'd rather include something in my SQL statement.

There are no numeric fields in my SELECT so SUM doesn't work. When I run the query in Query Analyser (SELECT COUNT(*) AS tot, field1, field2, field3, blah, blah blah) the tot column, all the way down the rows returned is a only a 1 and I need something that will return the total number of records in my recordset.