Re: (no subject)

> >
> > sorry to bother you again but i am still having 2 more problems. it
> > would be grateful if you help me out.
> >
> > 1. The query below is selecting the max value from the table. The
> > table can be blank so it will return me a null value which i need to
> > set to 0. How do i do it?
>
> select decode (max(i),NULL,0,max(i)) from myTable
>
I would prefer:

select value (max(i),0) from myTable

Walter Link

>
>
> _______________________________________________
> sapdb.general mailing list
> [email protected]
> http://listserv.sap.com/mailman/listinfo/sapdb.general