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" <nickf@ontko.com>
To: "Robson Martins" <robson-martins@bol.com.br>;
<pgsql-admin@postgresql.org>
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 nickf@ontko.com Phone 1.765.935.4283 Fax 1.765.962.9788
> Ray Ontko & Co. Software Consulting Services http://www.ontko.com/
>
>