On Tue, 20 Nov 2001, PostgreSQL List User wrote:
> Most of the problems I've benn able to fix, but there are a couple I
> would like to ask about:
>
> I have some querys that go like:
>
> SELECT FirstName + ' ' + LastName AS [Customer Name] FROM tblCustomers
in place of the + use the concat operator ||
you can find further help in the 'string' section in the user doc.