| title | String Operators (Transact-SQL) | Microsoft Docs | ||||
|---|---|---|---|---|---|
| ms.custom | |||||
| ms.date | 03/14/2017 | ||||
| ms.prod | sql-non-specified | ||||
| ms.prod_service | sql-database | ||||
| ms.service | |||||
| ms.component | t-sql|language-elements | ||||
| ms.reviewer | |||||
| ms.suite | sql | ||||
| ms.technology |
|
||||
| ms.tgt_pltfrm | |||||
| ms.topic | language-reference | ||||
| dev_langs |
|
||||
| helpviewer_keywords |
|
||||
| ms.assetid | ee4e715d-d8f1-4d0e-81b3-04573ec9f13c | ||||
| caps.latest.revision | 30 | ||||
| author | douglaslMS | ||||
| ms.author | douglasl | ||||
| manager | jhubbard | ||||
| ms.workload | On Demand |
[!INCLUDEtsql-appliesto-ss2012-xxxx-xxxx-xxx-md]
[!INCLUDEssNoVersion] provides the following string operators. String concatenation operators can combine two or more character or binary strings, columns, or a combination of strings and column names into one expression. Wildcard string operators can matches one or more characters in a string comparison operation such as LIKE or PATINDEX.
+= (String Concatenation Assignment)
% (Wildcard - Character(s) to Match)
[ ] (Wildcard - Character(s) to Match)