ISNULL is definitely the way to go.  Stay away from set concat_null_yields_null.  There is a bug in SQLServer that causes stored proc's & triggers to recompile and cause contention b/c...