Assuming there really are two records there, the problem is probably
that one of the fields in one of the records is null. If your
concatenation includes a null, the result is null, no matter what is
in the other fields.

This highly non-intuitive behaviour is claimed to be logical, because
if one of the elements of the concatenation is unknown, then the
result must also be unknown, hence null.



--- In ib-support@y..., "Rodrigo Garcia Lima" <rodrigogarcia@b...>
wrote:

> Friends,
>
> I´m trying to do this:
>
> select
> (F.CAMPO || F.CONDICAO || F.PARAMETRO || F.FINAL) AS FI from
> FILTROS F
> where
> F.CODIGO_FILTRO_MESTRE = :CODIGO_FILTRO_MESTRE
> order by
> F.CODIGO_FILTRO
>
> My table has two records, and the result most be:
>
> CODIGO_BAIRROdiferente de12E
> CODIGO_BAIRROdiferente de 11
>
> But is:
>
> CODIGO_BAIRROdiferente de12E
>
> Where's then other record?
>
> Thanks,
>
> Rodrigo Garcia Lima
> Brazil-Ceará-Fortaleza
>
>
> [Non-text portions of this message have been removed]