I have a field called DocumentType (Char(1)). There are 3 possible entries. e.g. 'A' or 'B' or 'C'
I want a view that explains the codes e.g. if the data is 'A' then I want to display 'Standard Order', if the data is 'B' then 'Billing' etc.
Does anyone know the syntax?