Hi

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
Chreos.com

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