title: Sybase Case Statement syntax error
body: <p>Im trying to run a case statement query in sysbase but i keep running into a error. The query is here</p>
  
  <pre><code>CASE WHEN table.TYPPAYT is '04' then 'Cash on delivery'
  ELSE table.TYPPAYT
  END
  </code></pre>
  
  <p>I have also tried it like this.</p>
  
  <pre><code>CASE WHEN table.TYPPAYT is '04' then 'Cash on delivery'
  ELSE table.TYPPAYT
  END
  </code></pre>
  
  <p>Both of these return syntax error near '04'</p>
  
  <p>When i run it like this it works but its not what i want</p>
  
  <pre><code>CASE WHEN table.TYPPAYT is  then 'Cash on delivery'
  ELSE table.TYPPAYT
  END
  </code></pre>
  
  <p>Any ideas?</p>