Weird SQL Concatenation

At work I automate reports that usually pull a really large chunk of data from several tables in our loan origination software.  Today I came across a report with a blank value where I was concatenating 2 fields together: CASE […]