Thread: Update Stuff-type

Hi Guys,

I was wondering what the best way to approach this next problem would be.

Here's the data:

Emp.Col1___Emp.Col2____Emp.Col3
305 _______Operator____Available Thursdays

When I'm archiving former employees from the Emp table,
we take the number from Col1 and the string from Col2 and place
them manually in Col3. (Don't worry, 305 is not a pk or index)

So I was thinking of doing an update query that would move 305 and Operator at the beginning of Col3 to look like this:

Emp.Col1____Emp.Col2____Emp.Col3
_______________________305 Operator Available Thursdays


I thought of using stuff, but I never know if there will be a value
in Col3 or not. I basically always want the former values of Col1 and Col2 to show in a specific order at the beginning of the Col3 column.

Thanks!

Hmmm...You know what...I think I figured it out:

UPDATE Emp
Set col3=col1+''+col2+'+''+col3

Anyone see any pitfalls with this or a better way to go about it?