case formula to rename columns

[rrmcguire]

Is it possible to rename columns for instance if I have a field called reason_for_leaving with the possible selections being AGT,AL, ATT, BKS, DIS, DL,DTI,EOB,FOL,FR

can I have it so if reason_for_leaving = 'AGT' then 'Agent and Driver Left' else if reason_for_leaving = 'AL' then 'Agent Left', etc.

 

[rrmcguire]

is through a software called DOMO that we use at our company, its a business intelligence software

 

[Andrzejek]

You are asking your question in forum183 so you get the answer in Microsoft SQL Server syntax.

Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.