I have a question about using a select statement. I have a standard select: select jan, feb, mar, apr, ytd from ea_reports. what I'd like to do is have the labels for my output be dynamic based on a variable. that is something like this: select jan as (if 11_MQY = 'M' then 'Jan', else '1QTR'), feb as (if 11_MQY = 'M' then 'Feb', else '2QTR'), mar as (if 11_MQY = 'M' then 'Mar', else '3QTR'), apr as (if 11_MQY = 'M' then 'Apr', else '4QTR'), ytd from ea_reports I know this is not correct syntax, but I've tried decode and case and can't get them to work. so I'm wondering is there a way to do it that the experts might know? or perhaps my use of decode was just wrong.. I could use some advice.