Subject Re: [firebird-support] String append question
Author Martijn Tonies
Hello Olaf,

> Oldstatus = oldstatus || oldstatpos; sadly, as result the
oldstatus-variable
> has the value NULL. The variable was supposed to 'oldstatpos + oldstatpos'
> and not null.
>
>
>
> Please, can you help me what's the matter?

NULL + (or || ) something becomes NULL.

If you want to transmogrify NULL into something else, you might
want to take a look at COALESCE, it's in the Docs folder.

Martijn Tonies
Database Workbench - development tool for Firebird and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com