Just a quick one I came accross this morning, If I use something like:
SELECT (Road + ', ' + Area + ', ' + City + ', ' County + ', ' Postcode) As Address FROM Employees WHERE ID = 1000
If all fields have data in them then it returns fine, however if any field has a 'NULL' value then the only thing returned is 'NULL'....
I'm a little confused as to why? Also is there a work around for it?
EDIT: I'm using SQL Server 2008R2