<p>How can we write an update sql statement that would update records and the 'set' value changes every time?</p>

<p>For example:
If we have records like this</p>

<pre><code>SomeNumber SomeV CurCode WhatCodeShouldBe
200802754 432 B08 B09
200802754 432 B08 B09
200802754 432 B08 B09
200808388 714 64B C00
200804119 270 64B C00
</code></pre>

<p>I wish to update each 'SomeNumber' record so that 'CurCode' will be same as 'WhatCodeShouldBe'</p>

<p>Thanks for any help!</p>

```
UPDATE yourtable SET CurCode = WhatCodeShouldBe
```