SQL Concatenating: NULL problem

06Feb

In a SELECT statement, after concatenating some columns (e.g. SELECT a+b+c), you may have the situation that there is no returning value for some row i.e. NULL. But if you select the columns seperately like (e.g. SELECT a,b,c) then you have some data. If you wondering why this happens here you get the answer. If you concatenate colums with other columns that contains the value NULL then the whole concatenated string is NULL.