---
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:
  - "operators [Transact-SQL], string concatenation"
  - "plus sign (+)"
  - "string concatenation operators"
  - "+ (string concatenation)"
dev_langs:
  - "TSQL"
---
# String Operators (Transact-SQL)
[!INCLUDE [SQL Server Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdbmi.md)]


[!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] 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)](../../t-sql/language-elements/string-concatenation-transact-sql.md)  
  
[+= (String Concatenation Assignment)](../../t-sql/language-elements/string-concatenation-equal-transact-sql.md)  
  
[% (Wildcard - Character(s) to Match)](../../t-sql/language-elements/percent-character-wildcard-character-s-to-match-transact-sql.md)  
  
[[ ] (Wildcard - Character(s) to Match)](../../t-sql/language-elements/wildcard-character-s-to-match-transact-sql.md)  
  
[[^] (Wildcard - Character(s) Not to Match)](../../t-sql/language-elements/wildcard-character-s-not-to-match-transact-sql.md)  
  
[_ (Wildcard - Match One Character)](../../t-sql/language-elements/wildcard-match-one-character-transact-sql.md)