Subject NULL in exprssions
Author Alberto Pesce
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]