what db?
you would do it with
nvl(act_val, val_if_null)
in oracle (i think :-)
--
dc
-----Original Message-----
From: Mickael [mailto:[EMAIL PROTECTED]
Sent: 01 March 2004 13:50
To: CF-Talk
Subject: SQL Brainblock
Hi All,
I am having trouble with an iif in SQL and was wondering if someone
could help me with the syntax.
here is one line of my query.
Round(((sum(ORIG_BAL) -Sum(wo_amount)) / sum(ORIG_BAL)) * 100,0) as
SalvageCollected
What I would like is to display a zero if the value is null or a zero
but I keep getting errors in syntax, I know that this is possible I am
just getting lost in my braces.
Thanks
Mike
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
- SQL Brainblock Mickael
- RE: SQL Brainblock d.a.collie
- RE: SQL Brainblock Andy Ousterhout
- Re: SQL Brainblock Mickael
- RE: SQL Brainblock Andy Ousterhout