title: Syntax for Azure Cosmos DB CONTAINS
body: <p>I have the following JSON Store on Azure Cosmos DB. </p>
  
  <pre><code>{
    "id": "4",
    "total": 10.46,
    "tax": 0.55,
    "soldItems": [
      {
        "item": "CHEESE NIPS 004400001300 F 1.97 D",
        "price": 1.97
      },
      {
        "item": "ROOT BEER 10.46",
        "price": 10.46
      }
      ]
  }
  </code></pre>
  
  <p>and I am getting no results from this query:</p>
  
  <pre><code>SELECT * from c where CONTAINS(c.soldItems.item, "BEER")
  </code></pre>
  
  <p>What would be the correct syntax to check for a string in an JSON object value?</p>