Subject Re: [firebird-support] IsNull sentence
Author Robert martin

I am still getting over my Holidays but I think the word you are after
is Coalesce. So your SQL is something like...

Select Coalesce(Field1, 0), Field 2, From Table

Hope thats right, I am on a new computer and cant look it up :-)

Robert Martin
Software Engineer

Tu Amigo Secreto wrote:

> Hi everyone...Does someone knows how can I do this sentence in SQL
> Server but in Firebird 1.5:
> Select IsNull(Field1, 0), Field 2, From Table
> I don't wanna use a SP to do this I wanna do in a single sentence
> Thanks

No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 265.6.10 - Release Date: 10/01/2005