Multiple like selection in the dynamic update statement

AndriyShepel — Mon, 12 Sep 2022 18:28:16 GMT

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

Re: Multiple like selection in the dynamic update statement

AndriyShepel — Mon, 12 Sep 2022 18:53:52 GMT

Figured just now:)

That approach works using the Match statement.

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