title: Can I create another column conditional to the value of another column in a SELECT statement of the view i'm building?
body: <p>I'm trying to create a column with values conditional to a previous column in the SELECT statement. Fwiw, column 3 will result in strings from 'Case 01' to 'Case 02' and is also a CASE statement.</p>
  
  <pre><code>CREATE VIEW name AS(
    SELECT column1, column2, colum 3,
  
      CASE
        WHEN SUBSTRING(column3,1,6) = 'Case 01'   THEN ...
        WHEN SUBSTRING(column3,1,6) = 'Case 02'   THEN ...
        WHEN SUBSTRING(column3,1,6) = 'Case 03'   THEN ...
  
      END AS column4
  
    FROM random_table
  </code></pre>
  
  <p>Basically, column4 will be created based on column3 values. Is this possible since the VIEW is not 'built' yet?</p>
  
  <p>Thanks</p>