Is there a way (in a single SELECT) to produce results under headings.

When I do a GROUP BY, I want a heading above each group to show the title.

I don't think it can be done without creating a R/W cursor first, then inserting the headers.

Can someone put me right/or advise me on this?
Thanks
Kev