I need to join three site address fields together into one string. The code works fine where there a re values in each of the three address fields. However as soon as one of the three fields is blank then the record returned is blank.
I have created this code to try and say if a field is blank put a "" . However it just keeps telling me there is a syntax problem.
CASE WHEN site_address2 IS NULL THEN (' ') ELSE site_address2
While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…