Unanswered: How do you concatinate when one value is Null?
I am trying to combine 2 fields in a SQL statement as follows:
Select Field1 + Field2 AS tablefields from table
However when Field2 is Null it makes the column tablefields null regardless of whether Field1 has data or not. Is there a way to avoid this?
The real SQL statement is a series of LEFT OUTER JOINS combining fields from different tables into one field, but if one of the fields is Null it makes the entire end result for that column Null.
it is Ok to post SQL questions into this forum, but it is very helpful, when you give a short hint about the database you use. If the question is to specialized, I will move the thread to the correct forum and send an email to the poster