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>
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
