Subject Re: [IBO] result fields concatenated null
Author Dennis McFall
At 05:53 PM 04/27/02 -0300, you wrote:
>I.NOME||'. '||TC.DESCRICAO||'. '||C.DESCRICAO AS CONTA
>
>When the field C.DESCRICAO is Null, my result CONTA is null to.
>Anyone can help-me? If any field of this concatenation will null, I don't
>want that the result was null.
>


One possible solution:

UPDATE ALGUMA_COISA SET DESCRICAO = '' '' WHERE DESCRICAO IS NULL;

Dennis McFall