String Operators (Transact-SQL)

Applies to: yesSQL Server (all supported versions)

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)