SQL CASE statement for UPDATE

[David Satz]

not sure I understand your diagram, but you use CASE when an UPDATE in the
same way as you do w/a select
--
HTH,
David Satz
Principal Web Engineer
Hyperion Solutions
{ SQL Server 2000 SP2/6.5 SP5a } { Cold Fusion 5 SP1 } { VSS }
(Please reply to group only - emails answered rarely)
-----------------------------------------------------------------
"james" <cowlibob@hotmail.com> wrote in message
news:3d1c8242$1@10.1.10.29...
>
> Ladies and Gentlemen,
> I've seen the SELECT CASE... statement, but wonder if there is a similar
> construct for the UPDATE?
>
> I'm trying to update one of two columns, based on the value of a third.
eg.
>
> here, I would like col1 to be updated
> +------+------+------+
> | col1 | col2 | col3 |
> +------+------+------+
> | 1 | 5 | col1 |
> +------+------+------+
>
> and here, I would like col2 to be updated
> +------+------+------+
> | col1 | col2 | col3 |
> +------+------+------+
> | 1 | 5 | col3 |
> +------+------+------+
>
> Is this possible in a single update statement?
>
> Thanks,
> James.

[james]

Ladies and Gentlemen,
I've seen the SELECT CASE... statement, but wonder if there is a similar
construct for the UPDATE?

I'm trying to update one of two columns, based on the value of a third. eg.

here, I would like col1 to be updated
+------+------+------+
| col1 | col2 | col3 |
+------+------+------+
| 1 | 5 | col1 |
+------+------+------+

and here, I would like col2 to be updated
+------+------+------+
| col1 | col2 | col3 |
+------+------+------+
| 1 | 5 | col3 |
+------+------+------+

Is this possible in a single update statement?

Thanks,
James.