The "1" is isolated for administrators, whether at the beginning, middle, or end of Group List. In other words, there's gonna be a space in there somewhere that you can use:
NOT 'Group List' LIKE "1 " + "%" AND NOT 'Group List' LIKE "%" + " 1 " +
"%" AND NOT 'Group List' LIKE "%" + " 1"
Mike White
Office: 813-978-2192
E-mail: [EMAIL PROTECTED]
"Tyrone Dee"
<[EMAIL PROTECTED] To: [email protected]
.COM> cc:
Sent by: "Action Subject: QUESTION: MENU - NOT
LIKE
Request System
discussion
list(ARSList)"
<[EMAIL PROTECTED]
ORG>
10/27/2006 09:16
Please respond to
arslist
**
I have a Menu that shows all Users from the USER Form - no problem.
I would like to restrict all users who are Administrators from the pull
down menu. I tried:
NOT 'Group List' LIKE "%" + "1" + "%"
However, this is not working as there are other groups with "1" in the
Group Number.
Any assistance would be greatly appreciated.
THANKS!
__20060125_______________________This posting was submitted with HTML in
it___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
