Thanks quantik! This last example is the only CASE stmt-based solution that worked for my more complicated table (many more rows and joins than the OP). The union...