title: How do I alias particular values in SQL?
body: <p>I will present a question about 'aliasing' values from a column. I will use days of the week as an intuitive example to get my question across, but I am <strong><em>not</em></strong> asking for datetime conversions. </p>
  
  <p>Suppose I have the following SQL script:</p>
  
  <pre><code>SELECT DaysOfWeek 
  FROM [databasename].[dbo].[tablename]
  </code></pre>
  
  <p>Now, the column <code>DaysOfWeek</code> will return string values of the days' names, i.e. "Monday," "Tuesday," and so forth.</p>
  
  <p>What if I wanted the query to return the integer 1 for 'Monday', 2 for 'Tuesday', and so forth? I would want to assign a particular value to each of the week's days in the <code>SELECT</code> statement, but I'm not sure how to go about doing that. </p>
  
  <p>I'm relatively new to SQL, so I just thought I'd ask for an intuitive method to perform such a task. </p>
  
  <p><strong>Edited to add:</strong> I'm only using days of the week and their respective integer representation as an easy example; my task does not involve days of the week, but rather employee code numbers and corresponding titles. </p>