Thanks for the help guys.....I ultimately came up producing the following code from your help:

SELECT RTRIM(a.name_last) + ', '+ RTRIM(a.name_first) + ' (' + RTRIM(a.user_login) + ')' AS student_name,

  CASE

  WHEN...