Re: How to filter zeroes in select statements

Use the decode function:

select decode(s1,0,s2,s1) from your_table;

Will return s2 if s1=0 but will return s1 if s1<>0

You said:
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

Mike Received on Wed May 29 1996 - 00:00:00 CEST