COMBINING ITEMS IN AN UPDATE

[DCB1]

HOW DO YOU COMBINE TO ITEMS IN AN UPDATE STATEMENT.
I.E.
UPDATE

SET [COLUMN.NAME] = "123456" AND TABLE.COLUMN.NAME
WHERE [CRITERIA]
THE STUFF BETWEEN THE QUOTES IS TEXT AND THE ITEM I WANT TO COMBINE IT WITH IS AN EXISTING COLUMN IN THE TABLE.

 

[MDXer]

I'm assuming this is in the underlyinf relational table?

is it a column from the same row? if so

Update myTable
Set MyColumn = 'NewValue' + otherColumn
where myColumn = 'Criteria'

Should work. If you want a value from another row then things can get a bit more complex

"Shoot Me! Shoot Me NOW!!!"
- Daffy Duck