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

I understand. I just had a very strong memory of using code like this before. Maybe it was on a SQL Server database which apparently allows you to do this.