• I didn't mean to imply that I was being forced. I was just trying to see if I was missing an aspect that would make it more useful in some places. But what it seems like is that there is no benefit over the tried and true method that most of us have been using for years with either coalesce or isnull.

    selectCOALESCE(@String1,'') + ISNULL(@String2,'')