On Mon, 2003-09-15 at 09:29, Prakash Jattani wrote: > hi thomas, > > 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 _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
