title: Getting an error when using CONCAT in BigQuery
body: <p>I'm trying to run a query where I combine two columns and separate them with an <strong>x</strong> in between. </p>
  
  <p>I'm also trying to get some other columns from the same table. However, I get the following error.</p>
  
  <blockquote>
    <p>Error: No matching signature for function CONCAT for argument types: FLOAT64, FLOAT64. Supported signatures: CONCAT(STRING, [STRING, ...]); CONCAT(BYTES, [BYTES, ...]).</p>
  </blockquote>
  
  <p>Here is my code:</p>
  
  <pre><code>SELECT
    CONCAT(right,'x',left),
    position,
    numbercreated,
    Madefrom
  FROM
    table
  WHERE
  Date = "2018-10-07%"
  </code></pre>
  
  <p>I have tried also putting a cast before but that did not work.</p>
  
  <p><code>SELECT Concast(cast(right,'x',left)), position,...
  </code>
  <code>SELECT Concast(cast(right,'x',left)as STRING), position,...
  </code></p>
  
  <p>Why am I getting this error? 
  Are there any fixes? 
  Thanks for the help.</p>