Hi,
Does anyone know if it is possible to use in Firebird a stored
procedure like a UDF?

For example, suppose I have defined a stored procedure like :

create procedure concat (param1 varchar(50), param2 varchar(50))
returns (output_string varchar(100))
as
begin
for select (:param1 || :param2) from rdb$database
into :output_string do suspend;
end ^

I would like to be able to call it in a way similar to :

select concat(contact.firstname, contact.surname) contact_name from
contact;

Any ideas? Thanks for your time in advance.

Jono