title: Google Query Language Concatenation
body: <p>Is it possible to concatenate the value from a column with a string in Google Query Language? I'd like to do something like this:</p>
  
  <pre><code>=QUERY('Business Income'!A1:E, "select 'Q' + quarter(A), sum(B) where A is not null group by 'Q' + quarter(A) label quarter(A) 'Quarter', sum(B) 'Income'")
  </code></pre>
  
  <p>Using data that looks like this:</p>
  
  <pre><code>Date          Amount
  ----------    -------
  01/01/2015    XXXX.XX
  02/01/2015    XXXX.XX
  03/01/2015    XXXX.XX
  04/01/2015    XXXX.XX
  05/01/2015    XXXX.XX
  ...
  </code></pre>
  
  <p>And I'd expect this for the output:</p>
  
  <pre><code>Quarter    Income
  -------    ---------
  Q1         $XXXXX.XX
  Q2         $XXXXX.XX         
  Q3         $XXXXX.XX
  Q4         $XXXXX.XX
  </code></pre>