title: How to write a LIKE query in Azure CosmosDB?
body: <p>I want to retrieve data from Cosmos DB with the following query:</p>
  
  <pre><code>SELECT * FROM c WHERE c.pi like '09%001'
  </code></pre>
  
  <p>(This is a SQL query, which I can use in MySQL)</p>
  
  <p>Here, <code>pi</code> is a string value, which can be <code>09001001</code> or <code>09025001</code>.</p>
  
  <p>Is there a way to use a <code>LIKE</code> command in Cosmos DB?</p>
  
  <p>I know that cosmos DB uses <code>CONTAINS</code>, but this cannot be used when you want to match specifically the beginning or end of the string.</p>