I have an issue with NULL values in my database. I have in my contacts database, a table with columns
Address1, Address2, Address3, Posttown etc.
For a function I am trying to return the data using the following Select statement
(Address1 + ',' + Address2 + ',' + Address3 + ',' + Posttown) AS Address,
I get the name and mobile number, and all the addresses where all the columns have been filled in.
But I don't get why, when one or more of the columns contain a null value, I get the whole thing returned as a null.
Can anyone help me out. Thanks in advance.