what can i do to update a column multiple times in same update query?
<p>I want to update a column multiple times in same update query. I have a table in ms SQL database I want to update a field than again update that field in the same update query. for example i have a column "col" in sample table what i want to do is to set "col" values to "x" than to "y" in same SQL statement.</p>

<pre><code>what i can do to achieve this?
</code></pre>