title: Combine varchar column with int column
body: <p>I have two columns in a SQL table, <code>fooId</code> (int) and <code>fooName</code> (varchar).</p>
  
  <p>Is there a way to select them both as one column with a space between them?</p>
  
  <pre><code>select fooId + ' ' + fooName as fooEntity
  from mytable
  </code></pre>
  
  <p>They're different types so I'm getting an error. </p>
  
  <p>This field will be databound directly in a control in the web app. </p>
  
  <p>SQL Server 2008</p>
  
  <p>(I'm a bit of a sql beginner)</p>