Subject | String Concatenation with null field |
---|---|
Author | FabrÃcio Fadel Kammer |
Post date | 2006-01-09T21:18:55Z |
Hi all,
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.
Thanks again
FabrÃcio F. Kammer
Conchal/SP Brazil
[Non-text portions of this message have been removed]
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.
Thanks again
FabrÃcio F. Kammer
Conchal/SP Brazil
[Non-text portions of this message have been removed]