... PADR(ICASE( ; nborrower_number_of_employees >= 250, "250 ") ; nborrower_number_of_employees >= 100, "100 - 249",; nborrower_number_of_employees >= 50, "50 - 99",; nborrower_number_of_employees >= 25, "25 - 49",; nborrower_number_of_employees >= 10, "10 - 24",; "0 - 9"), 10) as cRange ,; ICASE( ; nborrower_number_of_employees >= 250, 6 ; nborrower_number_of_employees >= 100, 5,; nborrower_number_of_employees >= 50, 4,; nborrower_number_of_employees >= 25, 3,; nborrower_number_of_employees >= 10, 2,; 1) as nPrint_Order ; FROM loan