Subject Re: [ib-support] String Concatenation in Firebird Stored Procedure
Author Markus Ostenried
At 05:19 02.02.2002 +0000, you wrote:
>Is there a way to concatenate strings inside a stored procedure. I
>am running FB1.0RC2 and have tried "&", "+" and "AND" and the
>compiler does not like any of them. I did not see a UDF function to
>do this either.

use the pipe character:

RESULT = FIELD1 || FIELD2

HTH,
Markus