How to use IN operator in Like operator using actuate birt

Hello Jeff,

Good day!

I will try to explain you with an example:-

Consider there was a text box, where user can enter multi-value by separating them using 'commas'. In the script section I have given IN operator for that textbox to filter the query by giving the user entered values.

If the value is 123456 we can get the value. But here the issue comes, the user may also enter the half value say, 123 but he must get all values starting with '123' so here I have to use LIKE operator. But he may enter multi-values with half values so I need to use LIKE operator along with IN operator.

Hope you got my point. Could you please suggest me how to use both the LIKE and IN operators in sql/mysql.

Thanks in advance.

Regards,

Sai