There is a possibility that one of the columns you concatenated might be null causing the final concatenated result to be null. To avoid this use
ISNULL[
^] to give a default value.
Eg:
SELECT ISNULL(naccount,'') + ISNULL(cname,'') AS cdata FROM table