Hi!
I have a function FUNC_SOLD that returns a single numeric value,not a selectable SP.

CREATE OR ALTER PROCEDURE FUNC_SOLD(p_year INTEGER,p_month INTEGER,p_day SMALLINT) RETURNS (SOLD NUMERIC(16,4)) AS ......
................................

I want to use this function into a SELECT statement passing fields as params,something like this :

SELECT a.year,a.month,a.daty,FUNC_SOLD(a.year,a.month,a.day) as sold FROM mytable

I know a selectable SP will work,but I want this to remain as it is.
Thanks for any suggestion.




[Non-text portions of this message have been removed]