Subject AW: [Firebird-general] Problems with NULL
Author Marc Geldon
Thank you for all your help!


-----Urspr√ľngliche Nachricht-----
Von: Przemyslaw Mistur [mailto:pmistur@...]
Gesendet: Freitag, 12. Dezember 2003 07:19
An: Firebird-general@yahoogroups.com
Betreff: Re: [Firebird-general] Problems with NULL



----- Original Message -----
From: "Marc Geldon" <Geldon@...>
Subject: [Firebird-general] Problems with NULL


> In mySQL it worked very well. In FB not! He tells me something about
datatype not known and so on. Also a CAST AS INTEGER does not work. How can
I convert this NULL into a 0?

Hi Marc, in FB 1.5 You can try this: COALESCE(MAYBE_NULL_VALUE_??, 0)

Regards,
Przemek.


Community email addresses:
Post message: Firebird-general@yahoogroups.com
Subscribe: Firebird-general-subscribe@yahoogroups.com
Unsubscribe: Firebird-general-unsubscribe@yahoogroups.com
List owner: Firebird-general-owner@yahoogroups.com

Shortcut URL to this page:
http://www.yahoogroups.com/community/Firebird-general

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/