OK Martijn Tonies,

But this is the unique form? My scripts will increase a lot in size with
this.

Thanks again,

Fabrício F. Kammer

-----Mensagem original-----
De: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] Em nome de Martijn Tonies
Enviada em: segunda-feira, 9 de janeiro de 2006 17:20
Para: firebird-support@yahoogroups.com
Assunto: Re: [firebird-support] String Concatenation with null field

> I'm with a new problem with concatenation now!
>
> If I try to concatene two string fields and one of them is NULL the
> concatenation result is NULL :-(
>
> How can I prevent this? I need to create some sql scripts to concatene
> some fields and I'm not able do know if the field is NULL or not.

Use COALESCE to turn the NULL into something else.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS
SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com



++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++





SPONSORED LINKS
Technical
<http://groups.yahoo.com/gads?t=ms&k=Technical+support&w1=Technical+supp
ort&w2=Computer+technical+support&w3=Compaq+computer+technical+support&w
4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w6=Micro
soft+technical+support&c=6&s=196&.sig=-XIO8GxY6hqd3NaD5WSEyw> support
Computer
<http://groups.yahoo.com/gads?t=ms&k=Computer+technical+support&w1=Techn
ical+support&w2=Computer+technical+support&w3=Compaq+computer+technical+
support&w4=Compaq+technical+support&w5=Hewlett+packard+technical+support
&w6=Microsoft+technical+support&c=6&s=196&.sig=B29J78SYXnNTjjMFBMznqA>
technical support Compaq
<http://groups.yahoo.com/gads?t=ms&k=Compaq+computer+technical+support&w
1=Technical+support&w2=Computer+technical+support&w3=Compaq+computer+tec
hnical+support&w4=Compaq+technical+support&w5=Hewlett+packard+technical+
support&w6=Microsoft+technical+support&c=6&s=196&.sig=7_je1A94xs82CFXUjE
qA6g> computer technical support
Compaq
<http://groups.yahoo.com/gads?t=ms&k=Compaq+technical+support&w1=Technic
al+support&w2=Computer+technical+support&w3=Compaq+computer+technical+su
pport&w4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w
6=Microsoft+technical+support&c=6&s=196&.sig=2zMAuRCo5cJrVBr1Bxa3_w>
technical support Hewlett
<http://groups.yahoo.com/gads?t=ms&k=Hewlett+packard+technical+support&w
1=Technical+support&w2=Computer+technical+support&w3=Compaq+computer+tec
hnical+support&w4=Compaq+technical+support&w5=Hewlett+packard+technical+
support&w6=Microsoft+technical+support&c=6&s=196&.sig=_ytYU7aXb57AVaeUfm
vLcA> packard technical support Microsoft
<http://groups.yahoo.com/gads?t=ms&k=Microsoft+technical+support&w1=Tech
nical+support&w2=Computer+technical+support&w3=Compaq+computer+technical
+support&w4=Compaq+technical+support&w5=Hewlett+packard+technical+suppor
t&w6=Microsoft+technical+support&c=6&s=196&.sig=4hRo6NXYavRAbTkaYec5Lw>
technical support

_____

YAHOO! GROUPS LINKS



* Visit your group "firebird-support
<http://groups.yahoo.com/group/firebird-support> " on the web.


* To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
<mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe

>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .


_____




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