Anand,

> 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';
>

Use the SQL operator - the double pipe symbol:

STR_RESULT = STR_RESULT || ' Processing...';


With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com