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: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] 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" <bob_woodw...@k2sports.com>
To:     "U2 Users List" <u2-users@listserver.u2ug.org>
Date:   10/31/2011 01:55 PM
Subject:        Re: [U2] Using 'MATCH'
Sent by:        u2-users-boun...@listserver.u2ug.org



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
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Reply via email to