title: sql select and replace
body: <p>I have a query that will show all the client information, and there is a column called sex, which 1 is female, 0 is male. How can I do another select on this result, that turn all the female record, turn the 1 to 100, male to 101?  ( 1 and 0 in the first query, they are bit, in the second they are nvarchar) (Mssql)</p>
  
  <pre><code>select * from tblClientInfo
  
  001 Derrick  0
  002 Mary     1
  </code></pre>
  
  <p>then, turn it to </p>
  
  <pre><code>001 Derrick  100
  002 Mary     101
  </code></pre>