title: Get Names from Values in a select statement + Sql server 2005
body: <p>Here is my query</p>
  
  <pre><code>Select Gender from Table
  </code></pre>
  
  <p>The result pane shows <br/>
  <code>1</code><br/>
  <code>1</code><br/>
  <code>1</code><br/>
  <code>2</code><br/>
  <code>2</code><br/></p>
  
  <p>But i want the results to be <br/>
  <code>Male</code><br/>
  <code>Male</code><br/>
  <code>Male</code><br/>
  <code>Female</code><br/>
  <code>Female</code><br/></p>
  
  <p>The names <code>Male</code> and <code>Female</code> wont be present in my database.... I want to just hardcode the names based on values from the select statement....</p>