after working for more than 10 years with sql based languages I discovered something new again. The case statement, which is pretty damn slow (table of a couple of million entries) but it saves me the time to work with some statistical software.