<div>
<pre><code id="code-20-37812807-1">Update YourTableA

set COL_A =  'X'

From tableF where tableA.ID = tableF.ID and tableF. AnyColumn ='Y' </code></pre>
</div>


Update YourTableA

set COL_A =  'X'

From tableF where tableA.ID = tableF.ID and tableF. AnyColumn ='Y' 

<div>
Well, this is not the solution I was hoping for. &nbsp;I'm trying to update the value of a column in a Select rather than a seperate &nbsp;operation.<br />
<br />
If what you have is the way I must go, then ok.
</div>


Well, this is not the solution I was hoping for.  I'm trying to update the value of a column in a Select rather than a seperate  operation.

If what you have is the way I must go, then ok.

<div>
If you need to update another value in case of non-existence:<br />
<br />
update TableX <br />
set Col_a = case when exists (SELECT TYPE FROM TABLEF WHERE &nbsp;ANYCOLUMN = 'Y') then 'X' else 'Z' end
</div>


If you need to update another value in case of non-existence:

update TableX
set Col_a = case when exists (SELECT TYPE FROM TABLEF WHERE  ANYCOLUMN = 'Y') then 'X' else 'Z' end

<div>
almost there<br />
<br />
your code: else 'Z' end<br />
<br />
I do not want the column changed if sub query returns nothing, so could I just say else Col_a?
</div>


almost there

your code: else 'Z' end

I do not want the column changed if sub query returns nothing, so could I just say else Col_a?

<div>
<div class="content wysiwyg-content">
I need to set a char column called COL_A to 'X' &nbsp;if the sub query below returns any rows:<br />
<br />
SELECT TYPE FROM TABLEF WHERE &nbsp;ANYCOLUMN = 'Y'.<br />
<br />
iF IT DOES NOT RETURN ANY ROWS, I NEED TO LEAVE IT THE SAME VALUE:<br />
<br />
<br />
So what I need to do in more english terms:<br />
<br />
Set COL_A = 'X' when exists (SELECT TYPE FROM TABLEF WHERE &nbsp;ANYCOLUMN = 'Y'.)<br />
&nbsp; &nbsp; else do not do anything to the column.
</div>
</div>


I need to set a char column called COL_A to 'X'  if the sub query below returns any rows:

SELECT TYPE FROM TABLEF WHERE  ANYCOLUMN = 'Y'.

iF IT DOES NOT RETURN ANY ROWS, I NEED TO LEAVE IT THE SAME VALUE:


So what I need to do in more english terms:

Set COL_A = 'X' when exists (SELECT TYPE FROM TABLEF WHERE  ANYCOLUMN = 'Y'.)
    else do not do anything to the column.

SUBQUERY or CASE STATEMENT or something

Sybase, a subsidiary of SAP, builds a client/server relational database management system. Products include Adaptive Server Enterprise (ASE), Adaptive Server Anywhere (ASA), Sybase Unwired Platform (SUP) for mobile applications, Afaria for enterprise mobile device management and IQ for data warehouse and big data applications.