String Operators (Transact-SQL)
Applies To: SQL Server 2014, SQL Server 2016 Preview
SQL Server provides the following string operators. String concatenation operators can combine two or more character or binary strings, columns, or a combination of strings and column names into one expression. Wildcard string operators can matches one or more characters in a string comparison operation such as LIKE or PATINDEX.