title: Convert bit type to Yes or No by query Sql Server 2005
body: <p>I Want convert <code>bit</code> type to <em>Yes or No</em> </p>
  
  <p><strong><em>For Example:</em></strong></p>
  
  <pre><code>SELECT FirstName, LastName, IsMale from members
  </code></pre>
  
  <p><strong><em>Results:</em></strong></p>
  
  <pre><code>Ramy    Said    1  
  </code></pre>
  
  <p><strong><em>Expected Result:</em></strong></p>
  
  <pre><code>Ramy    Said    Yes  
  </code></pre>