Try:
SELECT RazaoSocial || ' - ' || coalesce(Bairro || ' ','') || CGCCli As
Coluna FROM Clientes WHERE RazaoSocial Like '%A%';
>SELECT RazaoSocial + ' - ' + Iif(Bairro Is Null,'',Bairro + ' ') + CGCCli
As Coluna FROM
>Clientes WHERE RazaoSocial Like '%A%'
Regards,
Nick
--------------------------------------------------------------------------
Nick Fankhauser nickf@ontko.com Phone 1.765.935.4283 Fax 1.765.962.9788
Ray Ontko & Co. Software Consulting Services http://www.ontko.com/