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

That's what I'd expect. This is the same as if you'd written:

x=y
y=x

The changes have to occur in some order. You'll have to use a variable to hold one value temporarily.

Tamar