decode or not decode?

i have 3 fields A,B,C for each code but only one must be not null.

select code,a,b,c
from table

i want to find the rows where 0,2 or 3 fields are not null

i want to define a new field 'search_error' with decode clause but i don't know how!

thanks!!! Received on Tue Sep 11 2001 - 10:51:44 CDT