Re: DECODE Problem: NEED Solution

From: Mark Styles <styles-nospam_at_lambic.co.uk>
Date: Fri, 02 Jul 1999 14:02:56 GMT
Message-ID: <377cc646.19892163@news.intra.bt.com>

MADEIRA SALLY <softsense_at_home.com> instructed their monkeys to type:
>I am tring to use the DECODE Fucntion in a certain way and do not
>think I can but you all may have a solution:
>
>I want to be able to avaluate a value in the following Manner:
>
>DECODE(Status,NOT IN ('LC'),LoanBalance) OR
>DECODE(Status,<>('LC'),LoanBalance)

decode(status, 'LC', null, LoadBalance)

says 'if status is 'LC' then return null, else return LoadBalance'

Mark Styles
Oracle developer and DBA
http://www.lambic.co.uk/company Received on Fri Jul 02 1999 - 09:02:56 CDT