Re: Reports 2.5

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 10 Jan 2006 08:47:45 -0800
Message-ID: <1136911657.989502_at_jetspin.drizzle.com>


michael.brohan_at_esb.ie wrote:
> Hi,
>
> I have a query. I have a field on a summary report which is
> abbreviated i.e. New, Aft etc.
>
> I want to create another field which will give the full description
> i.e. New => New Tyres, Aft = Breakdown after hours etc.
>
> how is this done? I've done it before but can't remember?
>
> Any help appreciated
>
> Michael

One way is with DECODE.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Tue Jan 10 2006 - 17:47:45 CET

Original text of this message