title: Assign a value when for integer when USE select query
body: <p>This question is relevant to SQL Server. I have table with column called <code>gender</code> and 1 or 0 will be saved as integer. I want to know whether there is a method assign a label when I selecting it using <code>SELECT</code> statement. </p>
  
  <p>For example </p>
  
  <pre><code>SELECT gender 
  FROM emp
  </code></pre>
  
  <p>AND if 1 occur <code>Male</code> AND 0 occur <code>Female</code> should be displayed. </p>