"a string" + null returns "a string". did you check ssas?

in standard SQL 'a string' || null returns null.

it's worth a test.