STRING_ESCAPE Function in sql server 2016

Escapes special characters in texts and returns text with escaped characters. STRING_ESCAPE is a deterministic function, introduced in SQL Server 2016.

Syntax

STRING_ESCAPE (text, type) 

Text: it is an nvarchar expression representing the object that should be escaped.

Type: Escaping rules that will be applied. Currently the value supported is 'Json'.

See the example:

Return Types

Nvarchar (max) text with escaped special and control characters. Currently STRING_ESCAPE can only escape JSON special characters shown in the following tables.

Special character	Encoded sequence
Quotation mark (")	\"
Reverse solidus (\)	\\
Solidus (/)	\/
Backspace	\b
Form feed	\f
New line	\n
Carriage return	\r
Horizontal tab	\t
Control character	Encoded sequence
CHAR(0)	\u0000
CHAR(1)	\u0001
...	...
CHAR(31)	\u001f

See the example

SELECT     STRING_ESCAPE('[''    This is a special / "message" /'']', 'json') AS     escapedJson; SELECT STRING_ESCAPE('\   /  \\    "     ', 'json') AS escapedText;