I am trying to add to a string as follows:

set @Code = @Code + substring(@Name, @cs + 1, 1)

However, if @Code is initially ‘T’ and the substring returns ‘W’ instead of @Code being ‘TW’ it remains ‘T’. What am I doing wrong?

I tried using SET, SELECT, @Code = @Code +. @Code +=… nothing works.