Thanks to everyone. Your feedback and advice and very much appreciated.

--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...> wrote:
>
> At 11:46 AM 29/06/2008, you wrote:
> >Hi,
> >
> >I am looking for a way to run certain codes multiple times (like a
> >function call, without resorting to UDF) within a stored procedure, so
> >that the same codes will not be repeated within a stored procedure.
>
> You want an embedded procedure for this.
>
> Example:
>
> create procedure convert_my_value (input x smallint)
> returns (output y varchar(25))
> as
> begin
> Y = 'YADA TODAY IS ' ;
> IF (X IS NOT NULL) THEN
> Y = Y|| CAST (X AS VARCHAR(6));
> ELSE
> Y = Y|| 'UNSPECIFIED';
> END
>
> create procedure caller_proc (xx smallint, ...)
> ...
> declare yada varchar(25));
> begin
> ....
> execute procedure convert_my_value (:xx)
> returning_values(:yada);
> ...
> end
>
> ./heLen
>