Returning resultset from Stored proc

Hi,

I want to write a stored procedure which will perform a query and return the result. I know how to return values via IN OUT variables, but can I return a whole resultset?
Example code would be appreciated, the simpler the better.

thanks,

• Kev