title: CASE WHEN...INTO - Stored Procedure
body: <p>is there any way to do a CASE WHEN INTO Statement?</p>
  
  <pre><code>Create or replace procedure example
  AS
   Variable1 varchar;
   Variable2 varchar;
  
  BEGIN
      Select (CASE WHEN number = 1 THEN
                  This_thing INTO Variable1
              ELSE
                  That_thing INTO Variable2) The_Other
      FROM table;
  END;
  </code></pre>