json-functions-transact-sql.md

title	JSON Functions (Transact-SQL) | Microsoft Docs
ms.custom	SQL2016_New_Updated
ms.date	06/02/2016
ms.prod	sql-non-specified
ms.reviewer
ms.suite
ms.technology	dbe-json
ms.tgt_pltfrm
ms.topic	language-reference
helpviewer_keywords	JSON functions
ms.assetid	ec97d451-06af-44a3-8304-305d410cfc8e
caps.latest.revision	8
author	douglaslMS
ms.author	douglasl
manager	jhubbard

JSON Functions (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2016-asdb-xxxx-xxx_md]

Use the following functions to validate or change JSON text or to extract simple or complex values.

For more info about the built-in support for JSON in [!INCLUDEssNoVersion], see JSON Data (SQL Server).

Function	Description
ISJSON	Tests whether a string contains valid JSON.
JSON_VALUE	Extracts a scalar value from a JSON string.
JSON_QUERY	Extracts an object or an array from a JSON string.
JSON_MODIFY	Updates the value of a property in a JSON string and returns the updated JSON string.

See Also

Validate, Query, and Change JSON Data with Built-in Functions (SQL Server)
JSON Path Expressions (SQL Server)
JSON Data (SQL Server)