I'm creating a view for a table. One column is called action type (Char 1) and has one of the following value: C,U,D. I want to create a column that if it is a C, then return CREATED, if its a U return Updated, and if it is a D return Deleted

Can someone help me out with this?

Thanks
Kirk