What is wrong with the following?
SELECT ID, Forename + ' ' + Surname + '( ' + WName + ')' AS FullName
WHERE (Business_ID = 137)
ORDER BY Forename
It works fine if Forename and Surname are not null but if they are null but WName has a string 'Lorna', FullName is just blank when it should be 'Lorna'??