ELSE(CASE WHEN MonthlyWages=
Why do you check each case twice ?
I don't see why this would not work. It seems convoluted, why not one 'case' statement that iterates through all the possibilities ? Why not use 'as' to give your column a name ? If you have 8 bit fields, what happens if more than one is selected ? I think you havea design flaw and you meant one field to contain a value that maps to an enum.