Subject result fields concatenated null
Author Ronaldo Rezende Vilela Luiz
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.

--
Ronaldo Rezende
ronaldim@...
-----------------------------------------
Analista e desenvolvedor de sistemas
e solu��es Desktop, Client / Server,
Internet, Intranet.
Uberaba, MG - Brasil
2� Per�odo de Sistemas de Informa��o
Universidade de Uberaba
....