title: Change the text of all cells in a specific column in a Query () function
body: <p>I have the following query to combine three tabs in a Google spreadsheet:</p>
  
  <pre><code>=QUERY({'Stock 1'!A:N;'Stock 2'!A2:N;'Stock 3'!A2:N};"Select Col1, Col2, Col3, Col4 Where Col3&lt;&gt;''";1)
  </code></pre>
  
  <p>In the grouped tab (Total Stock) I want to change all cells of column D (Col4) to "Company 1"</p>
  
  <p>Is there any function similar to "set" in SQL?</p>
  
  <p>Example:</p>
  
  <p><a href="https://docs.google.com/spreadsheets/d/1zGaka_DK5SPeRE-LAB7pK7NJ6I9bRUx4G6cgb_4inGg/edit#gid=2081907934" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1zGaka_DK5SPeRE-LAB7pK7NJ6I9bRUx4G6cgb_4inGg/edit#gid=2081907934</a></p>