title: How to skip case sensitive in SQL Json_Value function
body: <p>I have used <strong>&quot;JSON_VALUE&quot;</strong> function in SQL Query.It works fine as per my requirement. I would like to know how to skip case sensitive in json field.Please check my example jsonData</p>
  <p><strong>Json Data: -</strong></p>
  <pre><code>{
    &quot;factoryID&quot;: &quot;4&quot;,
    &quot;yearID&quot;: &quot;2&quot;,
    &quot;loggedInUserID&quot;: &quot;43&quot;,
    &quot;pageIndex&quot;: &quot;1&quot;,
    &quot;pageSize&quot;: &quot;10&quot;,
    &quot;searchString&quot;: &quot;&quot;,
    &quot;whereString&quot;: &quot;&quot;
  }
  </code></pre>
  <p>but when I give field name in Camel case in Json_Value ,then its return null.Please advise how to skip case sensitive in <strong>&quot;Json_Value&quot;</strong></p>
  <p><strong>SQL:-</strong></p>
  <pre><code> set @FactoryID = JSON_VALUE(@JsonData,'$.FactoryID')
  set @YearID = JSON_VALUE(@JsonData,'$.YearID')
  </code></pre>
  <p>For Json Detail (Array) :-</p>
  <pre><code>    SELECT          
      JSON_VALUE(A.value,'$.FactoryID')FactoryID,
      JSON_VALUE(A.value,'$.YearID')YearID,
      JSON_VALUE(A.value,'$.CreatedUserID')CreatedUserID,
      JSON_VALUE(A.value,'$.ModifiedUserID')ModifiedUserID,
      JSON_VALUE(A.value,'$.TempID')TempID
  
  FROM OPENJSON(@JsonDetail) as A
  </code></pre>