Re: more than one return value from SPL?

# create procedure test( type as int ) returning int,int; # if type = 1 then # return 1; # else # return 2; # end if # end procedure # select name, zip, test(1), test(2) from customer; I don't see any other way to do this. ccs. -- Carlos Costa e Silva ccs@minimal.pt : I don't have multiple rows, just multiple return values. I will try to clarify: : : # create procedure test() returning int,int; : # return 1,2; : # end procedure : : and a following: : : # execute procedure test(); : : (expression) (expression) : : 1 2 : : # select name, zip, test() from customer; : : --> 684: Procedure (informix.test) returns too many values : : -- : Chris Drauch <cdr@xteam.co.at> ... just speaking for myself ... :