Re: How can i force a 0 in a SQL query?

Try:

select group_client, sum (decode (substr (substr (bill, 1, 4), '1000', 1, 0))   from client_bills
group by group_client; Received on Wed Jan 27 1999 - 07:35:33 CST