title: SQL select replace integer with string
body: <p>Goal is to replace a integer value that is returned in a SQL query with the char value that the number represents. For example: </p>
  
  <p>A table attribute labeled ‘Sport’ is defined as a integer value between 1-4. 1 = Basketball, 2 = Hockey, etc. Below is the database table and then the desired output.</p>
  
  <p><strong>Database Table:</strong></p>
  
  <pre><code>Player     Team     Sport
  --------------------------
  Bob        Blue     1
  Roy        Red      3
  Sarah      Pink     4 
  </code></pre>
  
  <p><strong>Desired Outputs:</strong> </p>
  
  <pre><code>Player     Team     Sport
  ------------------------------
  Bob        Blue     Basketball
  Roy        Red      Soccer
  Sarah      Pink     Kickball
  </code></pre>
  
  <p>What is best practice to translate these integer values for String values? Use SQL to translate the values prior to passing to program? Use scripting language to change the value within the program? Change database design?</p>