String Operators (Transact-SQL)

APPLIES TO: yesSQL Server noAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

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)