On Thu, 6 Jun 2002 17:43:28 -0300
"Robson Martins" <robson-martins@bol.com.br> wrote:
> What err ???
>
> SELECT RazaoSocial + ' - ' + Iif(Bairro Is Null,'',Bairro + ' ') + CGCCli As Coluna FROM Clientes WHERE RazaoSocial
Like'%A%'
>
Uh, there is no error in MS Access, but are two errors in PG: "+"and "iif()".
You need to use "||" and "CASE WHEN ... THEN ... END". See docs.
Regard,
Masaru Sugawara