Thank you!



Best regards



Olaf Kluge







_____

Von: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] Im Auftrag von Martijn Tonies
Gesendet: Dienstag, 18. November 2008 15:01
An: firebird-support@yahoogroups.com
Betreff: Re: [firebird-support] String append question



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. <http://www.upscene.com> com
My thoughts:
http://blog. <http://blog.upscene.com/martijn/> upscene.com/martijn/
Database development questions? Check the forum!
http://www.database <http://www.databasedevelopmentforum.com>
developmentforum.com



No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.175 / Virus Database: 270.9.4/1795 - Release Date: 17.11.2008
17:24




[Non-text portions of this message have been removed]