| title | String Operators (Transact-SQL) | ||||
|---|---|---|---|---|---|
| description | String Operators (Transact-SQL) | ||||
| author | rwestMSFT | ||||
| ms.author | randolphwest | ||||
| ms.reviewer | |||||
| ms.date | 03/14/2017 | ||||
| ms.prod | sql | ||||
| ms.prod_service | sql-database | ||||
| ms.technology | t-sql | ||||
| ms.topic | reference | ||||
| ms.custom | |||||
| helpviewer_keywords |
|
||||
| dev_langs |
|
[!INCLUDE SQL Server Azure SQL Managed Instance]
[!INCLUDEssNoVersion] 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.
+= (String Concatenation Assignment)
% (Wildcard - Character(s) to Match)
[ ] (Wildcard - Character(s) to Match)