title: Big Query Concat String in FROM Clause
body: <p>I have multiple tables like as follows in BigQuery:</p>
  
  <blockquote>
    <p>PROJECT_NAME.DATA_SET_NAME.TABLENAME0</p>
    
    <p>PROJECT_NAME.DATA_SET_NAME.TABLENAME1</p>
    
    <p>PROJECT_NAME.DATA_SET_NAME.TABLENAME2</p>
    
    <p>PROJECT_NAME.DATA_SET_NAME.TABLENAME3</p>
    
    <p>PROJECT_NAME.DATA_SET_NAME.TABLENAME4</p>
    
    <p>...</p>
  </blockquote>
  
  <p>I want to empty some of these tables via a loop but don't know how to call the <strong>CONCAT</strong> in <strong>FROM</strong> clause:</p>
  
  <pre><code>DECLARE count INT64 DEFAULT 0;
  WHILE count &lt; 1000 Do
    DELETE FROM CONCAT('PROJECT_NAME.DATA_SET_NAME.TABLENAME' , count ) WHERE TRUE;
    SET count = count + 1;
  END WHILE
  </code></pre>
  
  <p>But it's not working, it says I cannot use CONCAT in FROM part.
  Anyone knows how should I do it?
  Thanks</p>