String Operators (Transact-SQL)

Applies to: SQL Server (all supported versions) Azure SQL Managed Instance

SQL Server provides the following string operators. String concatenation operators can combine two or more of the following data types into one expression:

  • character or binary strings
  • columns
  • combination of strings and column names

Wildcard string operators can match one or more characters in a string comparison operation. LIKE and PATINDEX are examples of two of these operations.

Section Heading

+ (String Concatenation)

+= (String Concatenation Assignment)

% (Wildcard - Character(s) to Match)

[ ] (Wildcard - Character(s) to Match)

[^] (Wildcard - Character(s) Not to Match)

_ (Wildcard - Match One Character)