string-functions-transact-sql.md

title	String Functions (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	08/15/2016
ms.prod	sql
ms.prod_service	database-engine, sql-database, sql-data-warehouse, pdw
ms.reviewer
ms.technology	t-sql
ms.topic	language-reference
dev_langs	TSQL
helpviewer_keywords	functions [SQL Server], strings strings [SQL Server], functions string functions strings [SQL Server]
ms.assetid	6940a83d-5374-4af3-bb27-5d89c8af83ac
author	MashaMSFT
ms.author	mathoma
manager	craigg
monikerRange	>=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current

String Functions (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-all-md]

[!div class="nextstepaction"] Please share your feedback for the table of contents in SQL Docs!

The following scalar functions perform an operation on a string input value and return a string or numeric value:

ASCII	CHAR	CHARINDEX
CONCAT	CONCAT_WS	DIFFERENCE
FORMAT	LEFT	LEN
LOWER	LTRIM	NCHAR
PATINDEX	QUOTENAME	REPLACE
REPLICATE	REVERSE	RIGHT
RTRIM	SOUNDEX	SPACE
STR	STRING_AGG	STRING_ESCAPE
STRING_SPLIT	STUFF	SUBSTRING
TRANSLATE	TRIM	UNICODE
UPPER

All built-in string functions except FORMAT are deterministic. This means they return the same value any time they are called with a specific set of input values. For more information about function determinism, see Deterministic and Nondeterministic Functions.

When string functions are passed arguments that are not string values, the input type is implicitly converted to a text data type. For more information, see Data Type Conversion (Database Engine).

See Also

Built-in Functions (Transact-SQL)