Re: What err ???

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/
>
>