Ok, Nick.Masaru,Joel. Very Thanks! Nick. It helped sufficiently. :-)
Brasil vai ganhar a Copa do Mundo! Robson Martins >From Brazil ----- Original Message ----- From: "Nick Fankhauser" <[EMAIL PROTECTED]> To: "Robson Martins" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, June 07, 2002 12:49 PM Subject: RE: [ADMIN] What err ??? > 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 4: Don't 'kill -9' the postmaster
