title: Crystal Reports formula field IF LIKE
body: <p>I'm a little confused with Crystal Reports [LIKE] pattern operator, compared to SQL's [IN] operator.</p>
  
  <p>I have inherited maintenance of an old report that uses FORMULA FIELDS to qualify the data used in SELECTION FORMULAS > RECORD SELECTION.</p>
  
  <p>One of the FORMULA FIELDS uses [LIKE] to limit the records returned.</p>
  
  <p><strong>EXAMPLE IN CRYSTAL:</strong> </p>
  
  <pre><code>IF {table.column} LIKE ["A","B","C"]
  </code></pre>
  
  <p><strong>COMPARED TO SQL:</strong></p>
  
  <pre><code>SELECT * FROM table WHERE col1 IN ("A","B","C")
  </code></pre>
  
  <p>I can't find documentation that uses LIKE in this way. 
  Since I can't find supporting documentation for LIKE I question if this is the "best practice" for filtering content. Is there a better way?</p>
  
  <p>Thanks,</p>
  
  <p>-Allen</p>