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 [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
