title: How to replace fetched values with another column while querying with SQL Server 2008 R2
body: <p>Alright let me explain my question with example</p>
  
  <p>We have 1 table
  This table contains</p>
  
  <pre><code>Id
  Name
  Number
  </code></pre>
  
  <p>Now example</p>
  
  <pre><code>1 House 4
  2 Hospital 3
  3 Airport 1
  4 Station 2
  </code></pre>
  
  <p>Now when fetching as <code>select * from table</code></p>
  
  <p>I want to replace third column number values with that number representing Name</p>
  
  <p>So example of fetching</p>
  
  <pre><code>1 House Station
  2 Hospital Airport
  3 Airport House
  4 Station Hospital
  </code></pre>
  
  <p>How can i do this ? thank you</p>