title: SQL changing a value to upper or lower case
body: <p>How do you make a field in a sql select statement all upper or lower case?</p>
  
  <p>Example:</p>
  
  <p>select firstname from Person</p>
  
  <p>How do I make firstname always return upper case and likewise always return lower case?</p>