RE: SQL update using case

["Colpaert, Peter" <Peter.Colpaert@xxxxxxxxxxx>]

David,

you forgot the "=" :

update myTable set field1 =
   case when field2 = 'C'  then 'CLT' else 'AGT' end

This works (on my system at least).

HTH,


Peter Colpaert
Software Engineer, Philips Consumer Luminaires

Industrieterrein Satenrozen 11, 2550 Kontich, Belgium
Tel. +32/ 3 450 74 09, Fax +32/ 3 450 74 33, Internal 1317
peter.colpaert@xxxxxxxxxxx, www.philips.com

Simply Switch to printing double-sided and printing less






> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-
> bounces@xxxxxxxxxxxx] On Behalf Of David FOXWELL
> Sent: vrijdag 16 januari 2009 12:34
> To: Midrange Systems Technical Discussion
> Subject: SQL update using case
>
> Hi,
> Can anyone tell me what's wrong with this :
>
> update myTable set field1
>   case when field2 = 'C'  then 'CLT' else 'AGT' end
>
> Thanks
> --


The information contained in this message may be confidential and legally protected under applicable law. The message is intended solely for the addressee(s). If you are not the intended recipient, you are hereby notified that any use, forwarding, dissemination, or reproduction of this message is strictly prohibited and may be unlawful. If you are not the intended recipient, please contact the sender by return e-mail and destroy all copies of the original message.