How to return multiple results from function/procedure in Report Query?

Hi,
I have to return few values in Report query from server procedure/function. Yet i do this by multiple call to the function with other parameter:

SELECT id, MyFun(id,'1') result1, MyFun(id,'2') result2, MyFun(id,'3') result 3
FROM MyTable

Is there a way to do this with just one call of MyFun (or replace with procedure)?

Tnx in advance,
Mladen. Received on Tue Jun 11 2002 - 06:15:08 CDT