Thank you!

Daniel Rail wrote:

>Hi,
>
>At August 10, 2004, 10:36, Jorge Andrés Brugger wrote:
>
>
>
>>Hi.
>>
>>
>
>
>
>>I´ve a view with a left join between two tables, and I want to return 0
>>instead of null on a field of the second table. Is this posible?
>>
>>
>
>
>
>>Actual result set:
>>Field_1 Field_2
>>1 1
>>2 2
>>3 null
>>
>>
>
>
>
>>and I want:
>>1 1
>>2 2
>>3 0
>>
>>
>
>If you are using FB 1.5, you can use COALESCE to return the value 0
>instead of NULL. Look in the release notes for all the information.
>
>
>

--
Jorge Andrés Brugger
DASU - Obra Social del Personal de la Universidad Nacional de la Patagonia
Comodoro Rivadavia, Chubut, Argentina
Correo electrónico: jbrugger@...
Website: www.dasu.com.ar



[Non-text portions of this message have been removed]