Subject | Re: [firebird-support] String append question |
---|---|
Author | Martijn Tonies |
Post date | 2008-11-18T14:01:23Z |
Hello Olaf,
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
> Oldstatus = oldstatus || oldstatpos; sadly, as result theoldstatus-variable
> has the value NULL. The variable was supposed to 'oldstatpos + oldstatpos'NULL + (or || ) something becomes NULL.
> and not null.
>
>
>
> Please, can you help me what's the matter?
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