'Group List' LIKE "%20213%" OR 'Group List' LIKE "%20000%"
Also - try searching "search permission groups" instead of going against user form. Regards, Andrew Goodall Software Engineer | Development Services | jcpenney . jcp.com | 972.431.1518 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Phillips Sent: Friday, April 01, 2011 1:54 PM To: arslist@ARSLIST.ORG Subject: query against the user form group list field Happy Friday! I would like to search for all User form records where the group list is ONLY Service Request User and General Access. Service Request User group id = 20213 General Access group id = 20000 I'm having problems with the advanced query. Can anyone help? Thanks, Rick ARS 7.6.03 SQL 2005 ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"