You could write a stored procedure and do the selection in SQL, or another idea is to concatenate the values of the 70 fields into one formula field and then use the LIKE function to see if there is a 2 or a 3 in the formula field...
{FORMULAFIELD} LIKE "*2*" OR {FORMULAFIELD} LIKE "*3*"
(Not a pleasant solution with 70 fields, but it would work and would be faster than checking each field individually),
or you could create an array out of your fields and use IN to check the values in the array:
3 in[{field01},{field02},....{field70}]. I think that might work...
Edited by dbodell - 18 May 2012 at 11:21am
IP Logged
