Subject Re: [firebird-support] Concatenating Strings in SP
Author Lucas Franzen
> I am now facing another problem: How do I concatenate two
> strings and store the result in one of the strings used? For
> e.g. if I have a VARCHAR variable STR_RESULT in my SP. I want
> this variable to take values such as follows:
>
> STR_RESULT = 'START';
> STR_RESULT = :STR_RESULT + ' PROCESSING ...';
> STR_RESULT = :STR_RESULT + ' END';

STR_RESULT = 'START';
STR_RESULT = :STR_RESULT || ' PROCESSING ...';
STR_RESULT = :STR_RESULT || ' END';

Luc.