I need this query to return 00000000.00 if the calculation returns a NULL value, but I can't figure out where to put the NVL function:
SELECT ltrim(to_char((sum(decode(ic.cost_code,'MSG',(ic.amount*sol.ord_line_weight)/29413))),'09999999.99')) MSG,
Results 1 to 5 of 5
Thread: NULL value query
|
Click Here to Expand Forum to Full Width |