Read my earlier email on this topic. Using the Group ID with the ; at the end of the ID in the like statement is more likely to give you a more accurate result. Even doing so it is a good idea to make sure you have a convention at arriving at group ID's with a structured approach so that the like searches may not break things like it does if you perform a like search on the logical group names..
Every group ID in the C104 form is stored with ; as a termination character to it, so this can be used as an advantage if your Group ID's are well structured so as not to run into a limitation like you have.. Joe ----- Original Message ---- From: Shane Buchholz <[EMAIL PROTECTED]> To: [email protected] Sent: Wednesday, September 17, 2008 6:33:09 PM Subject: Similar Group Names ** I ran into an interesting problem today with group names that are similar. One group is called Quest, and another group has the word Request in it. Members of the group with Request in the name are seeing tickets assigned to the group called Quest without actually being members of the group. When I change the group name to have anything other than just Quest it works correctly. Has anyone seen this before, and maybe know the cause? I could not find anything on the Remedy Support site or in the ARList Archives. Any help would be appreciated. AR System – 6.3 Help Desk – 5.6 Windows 2003 Server SP2 SQL 8.0 Thanks, Shane Buchholz Information Security Specialist Remedy Administrator Account Services – Information Services _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
