RE: How to filter zeroes in select statements

Use the DECODE function ...

//Magnus Nyborg
email: many_at_lkp.ifsab.se

On den 28 maj 1996, Neal Gran wrote...
> I am trying to code a select statement in which one numeric field may
 

> take a value from one of two sources, s1 and s2. The condition is
 whether
> s1 is zero or not. I need something like the 'nlv' function,
> except for a zero value of s1 instead of a null value. I haven't found
> anything helpful in the Oralce SQL manual. Does anyone have any
> suggestions for this problem?
>
> -Neal Gran
>
>
Received on Mon Jun 03 1996 - 00:00:00 CEST