title: Crystal CASE expression with SQL example using CRYSTAL syntax
body: <p>How would a properly formed <code>CASE</code> statement with CRYSTAL syntax.
  I am creating a international Flag field on the report to show if the order number is a international order or domestic order and the report needs to show the Order type "International" or "Domestic" in the field based on the code snippet below.</p>
  
  <p>Here is a SQL example of what I am trying to accomplish.</p>
  
  <pre><code>Select
    CASE
       WHEN order.no like '6%' then 'International'
       Else "Domestic"
    END
  from Orders
  </code></pre>
  
  <p>As of now I have tried </p>
  
  <pre><code>select {Command.order_no}
  case is like '6%' : "International"
  default : "Other"
  </code></pre>
  
  <p>But I receive a error</p>
  
  <blockquote>
    <p>"One of the comparison operators &lt;,&lt;=,> or >= is expected here.`</p>
  </blockquote>