title: How do I perform a simple string mapping as part of a t-sql select?
body: <p>In T-SQL, I can do arithmetic as part of a select. For example, suppose I have a table Math with a column named Decimal. I can do the following query.</p>
  
  <pre><code>SELECT 100*Decimal FROM Math
  </code></pre>
  
  <p>I wonder if it's also possible to do logic in the SELECT where I create a mapping such as {
  A=>B, F=>Z} so that every time the column is A, it returns B, and every time the column is F, it returns Z.</p>
  
  <p>I apologize if this is a newb question, because I'm not very experienced in SQL.</p>