BTW, basically format is this DECODE(field, match 1, return 1, match2, return 2, ... no matches return)