If Field Contains?

[nightdesigns]

I have a field that has the contents set by a series of checkboxes.

So for instance, the contents could be 1,2,3

How can i tell the system to check to see if 2 exists, or 3 exists. I've used left and right words, but that woudln't give me to. is there a basic "if contains" command short of using the position command?

Thanks.

[-Queue-]

Multiple value list items selected in a field are separated by ¶. So

PatternCount( "¶" & fieldName & "¶", "¶2¶" )

or

Position( "¶" & fieldName & "¶", "¶2¶", 0, 1 )

will both return true (a non-zero value) when 2 is one of the items selected in the field. To force them to return a 1 when true, use

PatternCount( "¶" & fieldName & "¶", "¶2¶" ) or 0

or

Position( "¶" & fieldName & "¶", "¶2¶", 0, 1 ) or 0