Please, read my comment to the question.
I'd suggest to read this:
T-SQL: + (String Concatenation)[
^]
If
UserCode
field returns numeric values, you need to convert it to a varchar data type:
SELECT CONVERT(VARCHAR(30), UserCode) + 'EmailAddressInfo' AS NewFieldName
FROM User_Master