title: How to allow special characters in JSON_VALUE
body: <p>I have a table with a VARCHAR column I use as JSON. In the column is the following data: <code>{"Key-Name": "A value."}</code>.</p>
  
  <p>If I use JSON_VALUE to filter on this column with the query below I get the following error: "JSON path is not properly formatted. Unexpected character '-' is found at position 5.".</p>
  
  <pre><code>SELECT *
  FROM [MyTable]
  WHERE JSON_VALUE([Value], N'$.Key-Name') = 'A value'
  </code></pre>
  
  <p>How can I retrieve values with the JSON_VALUE function when keys have special characters in them?</p>