John,

M> I know a selectable SP will work,but I want this to remain as it is.

Then it will remain not working. :-)

I believe stored functions (that's what you want) are in the TODO list
but not available yet. Maybe if you state your requirements someone
could provide a workaround that works for you.

Ciao
--
Nando Dessena
======================================================
I support Firebird, I am a Firebird Foundation member!
Join today at http://www.firebirdsql.org/ff/foundation
======================================================