Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2004
    Posts
    6

    Unanswered: concatenate columns in sql 2000

    i need to concatenate two columns into one column in a table for sql 2000.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Has the teacher covered this in class yet? There are multiple ways to do it, and without knowing what they've covered or what the assignment actually says it is tough to guess which answer they want.

    -PatP

  3. #3
    Join Date
    Jun 2004
    Posts
    6

    Concatenating columns in SQL 2000

    I am simply trying to get some help. I am not a DBA, I am not in class for it, nor do I want to be one. I am a networking guy trying to get as much help as I can from other professionals. I have some basic familiarity with SQL but not much. I have to perform this concatenation for my job, but my company does not have a DBA either.

    Can anyone help??

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    If all you need is to get the job done, then I'd try using something like:
    Code:
    UPDATE myTable
       SET first_column = first_column + second_column
    -PatP

Posting Permissions

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