title: Convert JSON value by SQL query
body: <p>I have a JSON data in a field and I want to query base on one of the JSON columns but I receive converting error.
  I try these method but I receive convert error
  This is original query:</p>
  <pre><code>select * 
  from TableName 
  where json_value([Data],'$.Group.Field' ) &gt;= 1.1
  </code></pre>
  <p>and this is custom query:</p>
  <pre><code>select *  
  from TableName 
  where cast(JSON_VALUE([Data],'$.Group.Field') as decimal) &lt;&gt; ''
  </code></pre>
  <p>this is another one:</p>
  <pre><code>select *  
  from TableName 
  where convert(decimal, json_value([Data], '$.Group.Field')) &gt; 1.1 
  </code></pre>
  <p>but I get error with all of them:</p>
  <blockquote>
  <p>Error converting data type nvarchar to numeric</p>
  </blockquote>
  <p>this is JSON schema:</p>
  <pre class="lang-json prettyprint-override"><code>{
    &quot;Group&quot;: {
      &quot;Field&quot;: &quot;1.1&quot;
    },
    &quot;Group2&quot;: {
      &quot;Field2&quot;: &quot;1.1&quot;
    },
    &quot;Group3&quot;: {
      &quot;Field3&quot;: &quot;1.1&quot;
    }
  }
  </code></pre>