Re: DECODE Problem: NEED Solution

From: Roy Brokvam <roy.brokvam_at_conax.com>
Date: Fri, 2 Jul 1999 16:08:35 +0200
Message-ID: <zJ3f3.220$cR6.1768@news1.online.no>

MADEIRA SALLY wrote in message <377CC56A.FC5BBCEF_at_home.com>...
>hi,
>
>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)
>

Try DECODE(Status, 'L', TO_NUMBER(NULL), 'C', NULL, LoanBalance)

asuming LoanBalance is of type NUMBER.

Best regards,

Roy Brokvam
roy.brokvam_at_conax.com Received on Fri Jul 02 1999 - 09:08:35 CDT