-----Original Message-----
From: Mickael [mailto:[EMAIL PROTECTED]
Sent: Monday, March 01, 2004 9:13 AM
To: CF-Talk
Subject: Re: SQL Brainblock
I am using Access
----- Original Message -----
From: [EMAIL PROTECTED]
To: CF-Talk
Sent: Monday, March 01, 2004 9:28 AM
Subject: RE: SQL Brainblock
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]
