String operators (Transact-SQL)
Applies to:
SQL Server
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.