Results 1 to 2 of 2

Thread: join 2 fields string?

  1. #1

    Thread Starter
    PowerPoster
    Join Date
    Aug 2003
    Location
    Edinburgh, UK
    Posts
    2,773

    join 2 fields string?

    in SQL Server (2000) how can I join 2 field names together as 1 field?

    for example I have:

    FirstName
    LastName

    I want to join these 2 fields together to make 1 unique field "FullName"

    how?

    MVP 2007-2010 any chance of a regain?
    Professional Software Developer and Infrastructure Engineer.

  2. #2
    PowerPoster
    Join Date
    Oct 2002
    Location
    British Columbia
    Posts
    9,758

    Re: join 2 fields string?

    Select FirstName + " " + LastName As FullName From...

Posting Permissions

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



Click Here to Expand Forum to Full Width