Using multiple values in SearchExpr
Hi,
I have a requirement where I need to write script to search a BC field with multiple values. There are more than 30 values that should be searched. When we write an SQL statement, we can use an 'IN' clause for the search like this :
OWNER_DIV IN ('A' , 'B', 'C', 'D'...etc).
How can a similar thing be implemented through Siebel eScript when the maximum character limit is just 255 characters.
Please suggest a way of getting through this problem.
Thanks & Regards,
Maggi.