5e0a8e91   
   From: Plamen@SQLStudio.com   
      
   You can use a CASE expression:   
      
   SELECT grade,   
           CASE WHEN grade = 50 THEN 'F'   
                WHEN grade = 60 THEN 'D'   
                WHEN grade = 70 THEN 'C'   
                WHEN grade = 80 THEN 'B'   
                WHEN grade IN (90, 100) THEN 'A'   
           END AS letter_grade   
   FROM Grades;   
      
   --   
   Plamen Ratchev   
   http://www.SQLStudio.com   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)