title: I want to query the content of the json inside column like below
body: <p>I am saving JSON data my SQL server 2016 table and I want to query the table by applying where clause on the JSON like below.</p>
  
  <pre><code>select c.customer_details.name.fullName 
  from j_customer c 
  where c.customer_details.name.fullName like '%Gopi%';
  </code></pre>
  
  <p>this is possible in oracle but in mssql it gives the error like below</p>
  
  <blockquote>
    <p>Cannot call methods on nvarchar(max).</p>
  </blockquote>