> > > > 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 _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
