Re: migrating from MSSql - Mailing list pgsql-general

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.