I want to query the content of the json inside column like below
<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>