concatenate columns in sql 2000

carlm · #1 (**permalink**) 07-08-04, 15:37

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

Pat Phelan · #2 (**permalink**) 07-08-04, 16:40

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

carlm · #3 (**permalink**) 07-08-04, 18:08

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??

Pat Phelan · #4 (**permalink**) 07-08-04, 18:12

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

Internet Services

Web Development

Digital Marketing

Consumer Tech