isjson-transact-sql.md

title	ISJSON (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	07/17/2017
ms.prod	sql
ms.prod_service	database-engine, sql-database
ms.service
ms.component	t-sql|functions
ms.reviewer	douglasl
ms.suite	sql
ms.technology	dbe-json
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	ISJSON ISJSON_TSQL
helpviewer_keywords	ISJSON function JSON, validating
ms.assetid	c836f3d3-3e17-44ae-92bf-f341918896c3
caps.latest.revision	12
author	jovanpop-msft
ms.author	jovanpop
manager	craigg
ms.workload	On Demand

ISJSON (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2016-asdb-xxxx-xxx-md]

Tests whether a string contains valid JSON.

Transact-SQL Syntax Conventions

Syntax

ISJSON ( expression )  

Arguments

expression
The string to test.

Return Value

Returns 1 if the string contains valid JSON; otherwise, returns 0. Returns null if expression is null.

Does not return errors.

Remarks

ISJSON does not check the uniqueness of keys at the same level.

Examples

Example 1

The following example runs a statement block conditionally if the parameter value @param contains valid JSON.

DECLARE @param <data type>
SET @param = <value>

IF (ISJSON(@param) > 0)  
BEGIN  
     -- Do something with the valid JSON value of @param.  
END
 

Example 2

The following example returns rows in which the column json_col contains valid JSON.

SELECT id, json_col
FROM tab1
WHERE ISJSON(json_col) > 0 

See Also

JSON Data (SQL Server)