Hey- I need to use a 'case when' to categorize the right billcodes, for example, code 'A100', 'A101', 'A102', ..., 'A199' need to be put under 'Category 1'. however I want to find a short way using case when billcode in ('A100', 'A101', 'A102', ..., 'A199' ) then 'Category 1' I dont want to list 100 codes separately in the above parenthesis, do you know if there is a good/short way of doing that? Greatly appreciate!
... View more