string-functions-transact-sql.md

title	String Functions (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	08/15/2016
ms.prod	sql-non-specified
ms.reviewer
ms.suite
ms.technology	database-engine
ms.tgt_pltfrm
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
caps.latest.revision	29
author	BYHAM
ms.author	rickbyh
manager	jhubbard

String Functions (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-all_md]

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)