Hi…

I’m wondering if possible to swap values in database column using update script in sql server 2008!!
In this case I want to update all rows in one column by a single script.
For example if I have:

Table name: dbo.ABC
Column name: FGH
Rows value:
XXX 111 ZZZ 222
XXX 333 ZZZ 444
XXX 555 ZZZ 666
XXX 777 ZZZ 888

Rows value after swap update:
ZZZ 222 XXX 111
ZZZ 444 XXX 333
ZZZ 666 XXX 555
ZZZ 888 XXX 777

If possible ! how the script will be?

Regards…