<div>
try this<br />

<pre><code id="code-172779">update tableName
	set ColName = case when ColName= 'Fulltime' then 'Waiting' 
				 else
					case when ColName= 'Partime' then 'Placed' end
				end
</code></pre>
</div>


try this


update tableName
	set ColName = case when ColName= 'Fulltime' then 'Waiting' 
				 else
					case when ColName= 'Partime' then 'Placed' end
				end


<div>
update &lt;tablename&gt;<br />
set &lt;columnname&gt; = <br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; case &lt;columnname&gt; <br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;when 'Fulltime' then 'Waiting' when 'Partime' then 'Placed'<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; End <br />

</div>


update <tablename>
set <columnname> =
                      case <columnname>
                               when 'Fulltime' then 'Waiting' when 'Partime' then 'Placed'
                      End


<div>
It doesn't work, it says &quot;cannot update (column_name) to null&quot;
</div>


It doesn't work, it says "cannot update (column_name) to null"

<div>
Hi...the data in the column that just &nbsp;changed was created from other table, apparently it also change the original data. Is there anyway to avoid this? 
</div>


Hi...the data in the column that just  changed was created from other table, apparently it also change the original data. Is there anyway to avoid this?

<div>
<div class="content wysiwyg-content">
Hi,<br />
Can anybody help me....I have data in a column which contain:<br />
Fulltime<br />
Fultime<br />
Fulltime<br />
Partime<br />
Partime<br />
<br />
Now I want to change all fulltime words with Waiting and partime words with Placed.<br />
<br />
Do you know how to do this? <br />

</div>
</div>


Hi,
Can anybody help me....I have data in a column which contain:
Fulltime
Fultime
Fulltime
Partime
Partime

Now I want to change all fulltime words with Waiting and partime words with Placed.

Do you know how to do this? 


Combining two update queries

A programming language is a formal constructed language designed to communicate instructions to a machine, particularly a computer. Thousands of different programming languages have been created, mainly in the computer field, and many more still are being created every year. The description of a programming language is usually split into the two components of syntax (form) and semantics (meaning). Some languages are defined by a specification document (for example, the C programming language is specified by an ISO Standard), while other languages (such as Perl) have a dominant implementation that is treated as a reference. Some languages have both, with the basic language defined by a standard and extensions taken from the dominant implementation being common.

Programming Languages-Other

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.