DECODE Problem: NEED Solution

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)

I could supply the If..Then in the Decode statement with all the valid Status but there are 50 of them and I just want to exclude the LC's.

I am trying not to write a function call. Can I embed If...Then statement into SQL (ie. Case Statement in MS SQL 7)

Please Need help.

Thanks
Sally Received on Fri Jul 02 1999 - 08:54:23 CDT