Re: Searching on a field from multiple rows matching a groupId

[Jerry Malcolm]

Thanks for the quick response, Peter. COLX is simply a char field that can contain a string of characters which may or may not include the strings "abc" and/or "xyz". I just left the quotes off the strings in the example.

NDX GROUPID COLX
1 1 "aaa bbb abc ccc"
2 1 "ddd eee fff"
3 1 "ggg xyz"
4 2 "abc hhh iii"
5 2 "jjj kkk"
6 2 "lll mmm"