Is there a Case or Decode Type Function?
I have a report that contans a field called Entity. There are 5 different values for this field, (10, 20, 25, 30 ad 80). I have been asked to change the numeric value to a description. For example when the value is 10 display Philanthropy, when 20 display Medical Center etc. Is there are function that will allow me to translate or decode the numeric value into a text string?
I appreciate your help.