Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Location
    Inside Intel
    Posts
    165

    Question Unanswered: Concatenation of two columns

    Hi all,

    I am trying to concatenate two columns First_Name and Last_Name to display as Name in a View. I used the following statement but the result only shows the First_Name.

    Select First_Name + Last_Name as Name from Address;

    How do i combine the two columns??

    SQL 2000 running on Win 2000

    Thanks in advance.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    This is only a guess, but:
    Code:
    SELECT RTrim(first_name) + ',' + last_name
       FROM Address
    -PatP

  3. #3
    Join Date
    Apr 2004
    Location
    Inside Intel
    Posts
    165

    Talking

    Thank you for the prompt reply, it worked!

Posting Permissions

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