How to update SQL query with an identifier has 2 strings

[Steve-Mcl]

@Kimo

WHERE [Name] = '"+Name+"'"

that is not what I said to do...

@Steve-Mcl

WHERE [name] IN ('A1','A2')

e.g..

const array = flow.get('array'); //example ["A1", "A2"];
if(!array || !array.length) {
    node.warn("array is empty");
    return null // halt flow
}
const whereClause = "(" + array.map(e => "'" + e + "'").join(",") + ");"
const now = new Date().toLocaleString("en-GB");
msg.payload = "UPDATE [dbo].[Background] SET  [Start_Time] = '" + now + "' WHERE [Name] in " + whereClause;
return msg;