Use a Coalesce function like this (only in firebird
1.5) :

coalesce(B.field, 0) * coalesce(a.field, 0)


--- Alberto Pesce <palberto@...> a écrit :

>
> 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]
>
>
>
>
> Yahoo! Groups Links
>
>
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
>
>
>

Découvrez le nouveau Yahoo! Mail : 250 Mo d'espace de stockage pour vos mails !
Créez votre Yahoo! Mail sur http://fr.mail.yahoo.com/