On Thu, 6 Jun 2002, Robson Martins wrote: > What err ??? > > SELECT RazaoSocial + ' - ' + Iif(Bairro Is Null,'',Bairro + ' ') + CGCCli As Coluna >FROM Clientes WHERE RazaoSocial Like '%A%'
Messages like this are better sent to pgsql-general or pgsql-sql, by the way. Two problems: . Strings are concatenated using ||, not +. 'Cat' || 'Dog' => 'CatDog', whereas 'Cat' + 'Dog' => ASCII result of this (not what you want) . IIf() is a nonstandard Microsoft function used in Access. SQL databases use CASE. See the docs for examples on CASE. - J. -- Joel BURTON | [EMAIL PROTECTED] | joelburton.com | aim: wjoelburton Independent Knowledge Management Consultant ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
