I have these SQL:
Code: Select all
SELECT CC.*,
(CC.Desc || CC.Desc2) AS FK_PLANOPAI_DESC
FROM CAIXA_CONTA CC
where (CC.IDEMPRESA = 1) and
(CC.ANA_SIN = 'A')
ORDER BY CC.IDCAIXA_CONTA
Where I mess up?
Regards,
Code: Select all
SELECT CC.*,
(CC.Desc || CC.Desc2) AS FK_PLANOPAI_DESC
FROM CAIXA_CONTA CC
where (CC.IDEMPRESA = 1) and
(CC.ANA_SIN = 'A')
ORDER BY CC.IDCAIXA_CONTA
Code: Select all
select cast((CC.Desc || CC.Desc2) as character varying(600)) AS FK_PLANOPAI_DESC