title: How to handle dollar ($) sign in JSON_VALUE path
body: <p>We store data as a JSON string in our database.
  Due to the use of Newtonsoft JSON, this data contains fields that have $ signs in the key.</p>
  
  <p>Is it possible to query these fields using the JSON_VALUE function in MSSQL?</p>
  
  <p>The query I tried throws exception <em>JSON path is not properly formatted. Unexpected character '$' is found at position 2.</em></p>
  
  <pre><code>SELECT JSON_VALUE(JsonData, '$.$type') FROM dbo.JsonTable
  </code></pre>
  
  <p>The JsonData looks like this:</p>
  
  <pre><code>{
     "$type": "Project.Classes.JsonType",
     "amount": 50
  }
  </code></pre>