title: REGEXP_CONTAINS order and Case statement in bigquery
body: <p>I'm using case statement and REGEXP_CONTAINS.Just wanted to see if the following order will give me the correct output.</p>
  <pre><code> (CASE 
   WHEN REGEXP_CONTAINS(AdSet, '(?i)BUS') THEN &quot;BUS&quot;
   WHEN REGEXP_CONTAINS(AdSet, '(?i)BRA') THEN &quot;BR&quot; 
   WHEN REGEXP_CONTAINS(AdSet, '(?i)DIG') THEN &quot;TR&quot;
   WHEN REGEXP_CONTAINS(AdSet, '(?i)INS') THEN &quot;INS&quot;
   WHEN REGEXP_CONTAINS(AdSet, '(?i)INV') THEN &quot;INV&quot;
   WHEN REGEXP_CONTAINS(AdSet, '(?i)SAV') THEN &quot;SAV&quot;
   WHEN REGEXP_CONTAINS(AdSet, '(?i)TRA') THEN &quot;TR&quot;
   WHEN REGEXP_CONTAINS(AdSet, '(?i)CC')  THEN &quot;CC&quot;    
   WHEN REGEXP_CONTAINS(AdSet, '(?i)HL')  THEN &quot;HL&quot;
   WHEN REGEXP_CONTAINS(AdSet, '(?i)BR')  THEN &quot;BR&quot; 
   
    
   END) as pf
  </code></pre>