Dynamic Update - WHERE ID IN (1,2,3,4)

[#1]

Can anyone help me to get the correct dynamic update syntax here

These don't seem to work

UPDATE TABLENAME SET GROUPID = 1 WHERE ID IN (1,2,3,4);

UPDATE TABLENAME SET GROUPID = 1 WHERE ID=1 OR ID=2 OR ID=3 OR ID=4;

Thanks in advance!

Felix

[yoganantha321]

Hi Richard,

I have tried with the first one update query it is working perfectly,

Kindly try once again with

Update <tablename> set <fieldname> =<value> where <fieldname> in (<values for condition>);

Example I have used the below expression,

Update dbo.tbl_Womens_Registration set emp_Id =1 where emp_id in(101,102,103);

and got output as shown below

[#3]

That works, as you have demonstrated, in SQL. I'm talking about Qlikview Dynamic Updates