title: How do i use the like operator in a case select for Postgres SQL?
body: <p>I would like to write an SQL statement with a CASE WHEN clause that uses the LIKE operator but I am not sure how to properly format the statement.</p>
  
  <pre><code> SELECT
     services.id,
     (CASE services.description
       WHEN LIKE '%-'
         THEN services.amount * -1
       ELSE services.amount
     END) AS service_amount
   FROM services
  </code></pre>