Subject Re: [firebird-support] Query
Author Jason Dodson
Use coalesce in place of your psuedofunction isnull:

select A.nam, coalesce(A.f1,0)
from table1 as B left join table2 as A on A.f2=B.Cod

Oscar Villacis wrote:
> Hi friends:
>
> I want to do a SQL query like this in firebird:
>
> select A.nam, isnull(A.f1,0)
> from table1 as B left join table2 as A on A.f2=B.Cod
>
> Or
>
> select case a.f1 when null then 0 else a.f1 end
> from table1 as B left join table2 as A on A.cod=B.Cod
>
>
> It is possible?
>
> Thanks in advance.
>
>
> Oscar Villacis
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>