Thanks a lot Martijn, this will do perfectly for me!
Adam

--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@u...> wrote:

> 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