> >Something like (in VFP)
> >
> >SQLEXEC(nHandle, [SELECT * FROM MY_PROCEDURE(?iID, ?cFlag)],'XROW')
> >cRetValue = EVALUATE(xrow.narrtemplate)
> >
> >If you really need dynamic parsing/concatenation to be done by
> >Firebird, you need some UDFs for this.
>
> UDF's and Store procedures are one and the same, right?

No, UDFs are actually something that should be better named
"external functions". Those are functions in a dll or shared object
(linux) without a database context. They can be written in any
language that can compile dlls.

Stored Procedures are stored inside a database and have
access to tables, other procedures and the like. They are
written in the Firebird stored procedure language.

With regards,

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