Compare two value lists and find ANY matches
Posted on 2006-06-22
What is the best way to compare two value lists and return TRUE if ANY matches are found. For instance...
Value List #1 = Item1, Item3, Item5, Item7
Value List #2 = Item2, Item3, Item4
should return TRUE since Item3 in in both lists.