| title | String Operators (Transact-SQL) | Microsoft Docs | ||||
|---|---|---|---|---|---|
| ms.custom | |||||
| ms.date | 03/14/2017 | ||||
| ms.prod | sql | ||||
| ms.prod_service | sql-database | ||||
| ms.reviewer | |||||
| ms.technology | t-sql | ||||
| ms.topic | language-reference | ||||
| dev_langs |
|
||||
| helpviewer_keywords |
|
||||
| ms.assetid | ee4e715d-d8f1-4d0e-81b3-04573ec9f13c | ||||
| author | rothja | ||||
| ms.author | jroth |
[!INCLUDEtsql-appliesto-ss2012-xxxx-xxxx-xxx-md]
[!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)