title: How to apply string query filters in Odata
body: <p>My Odata collection returns a collection which includes the following field: </p>
  
  <pre><code>&lt;d:ColorFlagInfo&gt;Red,Blue&lt;/d:ColorFlagInfo&gt;
  
  &lt;d:ColorFlagInfo&gt;Red,Green&lt;/d:ColorFlagInfo&gt;
  
  
  &lt;d:ColorFlagInfo&gt;Black,Brown&lt;/d:ColorFlagInfo&gt;
  </code></pre>
  
  <p>Can someone please help me with constructing an Odata query that filters by one or more particular color:</p>
  
  <p>I’ve tried the following to get a particular color:</p>
  
  <p><a href="http://odata.test.com/cars" rel="nofollow">http://odata.test.com/cars</a>?$filter=substringof(‘Black’, ColorFlagInfo)</p>
  
  <p><a href="http://odata.test.com/cars" rel="nofollow">http://odata.test.com/cars</a>?$filter= ColorFlagInfo%20eq%20'Black'</p>
  
  <p>How would I find all ColarFlagInfo containing the color green?</p>