<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style>
</head>
<body class='hmmessage'>
Hello,<BR><BR> <BR><BR>I try to update one column value based the other two column values´s conditions. This code works<BR><BR><BR><BR>select book, case when table1.price>200 and table1.price<400 then '40'else book end from table 1 where table1.catalog='112'; <BR><BR> <BR><BR>Now I want to update the table1, so the book value will change into 40 when the other two conditions are true. <BR><BR> <BR><BR>update book, case when table1.price>200 and table1.price<400 then '40' else book end from table 1 where table1.catalog='112';<BR><BR> <BR><BR>It gives error. Can anyone help me? <BR><BR> <BR><BR>Thanks<BR><BR> </body>
</html>