Be careful using a straight count, Because "HELL" will be found in in the word "HELLO" for instance, and would not be added Make sure you surround your search criteria with the delimiters being used, as noted in one of the replies.
So, ,HELL, would not be found if ,HELLO, were in the list. George -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Greg Coelho Sent: Monday, October 31, 2011 4:15 PM To: U2 Users List Subject: Re: [U2] Using 'MATCH' Guys, Thanks for the great suggestions. I believe that I did get MATCH confused with COUNT thinking that it could navigate a delimiter... In this situation I'm thinking that just using COUNT would be the best solution. I do appreciate the diversity of the solutions presented. Thanks! Greg From: "Woodward, Bob" <[email protected]> To: "U2 Users List" <[email protected]> Date: 10/31/2011 01:55 PM Subject: Re: [U2] Using 'MATCH' Sent by: [email protected] You might also be able to use COUNT. IF COUNT(X.STRING,X.CODE) = 0 THEN X.STRING := X.CODE Not knowing what your potential codes are, though, they may or may not fit your needs. _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
