Search notes:

SQL Server: datatype varchar

SQL Server 2019 has full support for storing UTF-8 characters in a varchar. The collation must be set to a value with an utf8 suffix, for example latin1_general_100_ci_as_sc_utf8.

Concatenating strings

Two varchars can be concatenated with the + operator:

declare
   @str_1  varchar(10) = 'hello',
   @str_2  varchar(10) = 'world';

   print(@str_1 + ' ' + @str_2 + '.');
go

Github repository about-MSSQL, path: /t-sql/data-types/varchar/plus.sql

SQL Server: datatype varchar

Concatenating strings

See also