title: Is there a LIKE operator in odata filter?
body: <p>I'm trying to filter my data through OData where the field <strong>FileRef</strong> contains lets say <code>&quot;/The root path/folder/subfolder&quot;</code>, I tried with <code>substringof</code> like so:</p>
  <p><code>$filter=substringof(&quot;sites/my folder/subfolder&quot;, FileRef)</code></p>
  <p>But it seems doesn´t work, so I wonder if is there an operator <strong>like</strong> or something that i can use for achieve this.</p>