Is it possible to use COALESCE function inside a function as a cursor variable? test cursor (myvar varchar) for (coalesce(SELECT...<snip>,0)); I get a syntax error when trying this...ERROR: syntax error at or near "COALESCE"...is there a way to do this? -- Robert