Subject | NULL in exprssions |
---|---|
Author | Alberto Pesce |
Post date | 2005-02-20T09:43:12Z |
Hi all,
How can I get in a Query this
if B.field = NULL
A.field * B.field = 0
else
A.field * B.field = X
Using a join I obtain that if B.field = NULL, A.field * B.field = NULL
Thanks all !!!
Bye
Alberto Pesce
[Non-text portions of this message have been removed]
How can I get in a Query this
if B.field = NULL
A.field * B.field = 0
else
A.field * B.field = X
Using a join I obtain that if B.field = NULL, A.field * B.field = NULL
Thanks all !!!
Bye
Alberto Pesce
[Non-text portions of this message have been removed]