Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002
    Location
    Lund, Sweden
    Posts
    8

    Unanswered: concatenate two varchar fields

    Hi there.

    I have a (stupid question). I have a table containing user information. I want to create a fullname from first- and lastname fields.

    I assumed, but was wrong, that the following query would manage:

    SELECT firstname+' '+lastname AS fullname FROM Users;

    Any ideas how this should be done?

  2. #2
    Join Date
    Sep 2001
    Location
    Vienna
    Posts
    400

    query

    try this


    SELECT firstname || ' ' || lastname AS fullname FROM Users;
    http://www.postgresql.org
    --Postgresql is the only kind of thing--

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •