On Thu, 6 Jun 2002 17:43:28 -0300
"Robson Martins" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
