Compare Lists Boolean?

[pctechtv]

I have the result in a return separated list (it came from ExecuteSQL) something like this:

DOC000000095

LNK000000080

LNK000000081

I also have another list

DOC000000081

DOC000000088

DOC000000089

DOC000000090

DOC000000091

DOC000000093

DOC000000094

DOC000000095

DOC000000096

What is a way FileMaker can say if any of the values in List 1 exit List 2 evaluate as true? I was trying to use FilterValues ( ) Inside of PatternCount () but it went sour and I forgot the whole plan.

[Raybaudi]

Any: ValueCount ( FilterValues ( List2 ; List1 ) )

 

All: ValueCount ( FilterValues ( List2 ; List1 ) ) = ValueCount ( List1 )