Hi Adam,

> Is it possible to use Stored Procedures as (UD) Functions, ie. having
> declared a procedure XY is there a way to use the "select col1, XY
> (col2) from foo" or similar syntax? Or any ideas to achieve this? (I
> know that I could do it with a select procedure that would return the
> same thing using an execute procedure in a select loop, but I am
> looking for something that looks more like a selection).

Pretty much the only thing you can do is:

select col1, (select outputparam from xy(col2) )
from foo


With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird & MS SQL Server.
Upscene Productions
http://www.upscene.com