You can't combine an IN LIST with LIKE. You could build a series of OR statement like this:
id = {"R8D-304%","R8D-404%","R8D-515%"};
for (i = 1, i <= nitems(id), i++,
one_item = id[i];
if (i == 1,
sql_statement = evalinsert("SELECT WHERE serial LIKE '^one_item^'");
,
sql_statement = evalinsert("^sql_statement^ OR serial LIKE '^one_item^' ");
);
);
show(sql_statement);
sql_statement = "SELECT WHERE serial LIKE 'R8D-304%' OR serial LIKE 'R8D-404%' OR serial LIKE 'R8D-515%' ";