title: Coalesce and Concat in the same statement, Postgres
body: <p>I am trying to concat an individual's first and last name together but coalesce a team name when there is a null value. Unfortunately my syntax is returning a SPACE, so coalesce does not recognize it as a null value.. What can I do to correct this? </p>
  
  <p>Syntax I am currently using: </p>
  
  <pre><code>coalesce((Concat(first_name,' ',last_name)),team_name)
  </code></pre>