returning three select statements from a function

I want to return the output from three diiferent select statements (by a function) like this:

name   date       issueNumber
      ----- ---------- ----------- -------

r_date     prodID
           ---------- ----------- -------

date issueNumber
---------- -----------
(0 row(s) affected)

I was using ref cursor to return a single select statement. Is it possible to return all three from a single function. I would appreciate your input.

SP Received on Tue Jun 13 2000 - 00:00:00 CDT