Multiple like selection in the dynamic update statement

[AndriyShepel]

Hi folks!

I am digging into the specifics of the dynamic statement and wonder whether there's an option to use the like match based on the multiple values.

The working file is attached, but the short requirement is below:

I need to set Amount to 0 on the lines WHERE ID = 'bn' or 'ryku' or 'j'. 
Also, i really need only ONE update statement instead of multiple.

Previously i remember using one working version like this, but can't find the right syntaxis.

UPDATE DATA SET "Amount"=0 WHERE ID like 'ryku', 'bn', 'j'; 

 Much appreciate any help

[AndriyShepel · Accepted solution]

Figured just now:)

That approach works using the Match statement.

Update Data SET "Amount"=0 WHERE Match(ID, $(vValues));