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