title: SQL JSON - How to modify boolean value present in the Json Data
body: <p>How can I modify the existing boolean value of a json data in SQL Server 2016 - Json?</p>
  
  <p>Below is the script for inserting json Data.</p>
  
  <pre><code>DECLARE @a nvarchar(max) = N'{"employeeName":"Test","isActive":true}';
  
  insert into TestTable(testId,name,jsonData) Values('1','Test',@a) 
  </code></pre>
  
  <p>I tried to update using below query, but it returns 
  <em>Invalid column name 'false'.</em></p>
  
  <pre><code>update TestTable
  set jsonData = JSON_MODIFY(jsonData,'$.isActive',false)
  </code></pre>