I'm trying to switch the values from two columns. Here's my code:

update Items;
   SET cDesc = cIntDesc ;
   , cIntDesc = cDesc

This is a VFP database.

Shouldn't that work?

What is happening is that both columns get the original value that was in cIntDesc.