Re: What err ???

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>
Subject: Re: What err ???
Date: 2002-06-07 15:49:26
Message-ID: NEBBLAAHGLEEPCGOBHDGOEHEFBAA.nickf@ontko.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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/

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Oliver Elphick 2002-06-07 16:02:49 Re: What err ???
Previous Message Masaru Sugawara 2002-06-07 15:23:30 Re: What err ???