Limiting the result set

Hi guys,

I got a bit of an interesting problem I'm hoping someone can help me solve.

I've got a table that's got over 12000 entries in it and user's can run
searches on it via the
web. Now, I only ever want to return a maximum of 500 results (for speed
purposes) for any search.

Now, I've got that right by using the LIMIT command, but I also want to be
able to tell the user
how many records matched their search criteria. So I want to say something
like

"Your search matched 1234 items. These are the first 500" or some such
thing.

Is there any way, IN ONE QUERY, to do this. So I want to basically return
the first 500 results
and a count of the total result set in one go. Is this possible?

If not, what would be the quickest way to do this? The reason I need one
query is because I use
dynamic SQL, which complicates stuff a bit more

Thanks

Rob
---

He who dies with the most toys ...

... still dies