Alfredo:
Yes. LIKE will force a full table scan as you are looking for part of a word. HOWEVER, that being said, Group is much different as the text value is converted into a numeric and then searched for. This may NOT force a table scan but I don't know if you indexed the field so I don't know if it would use it in your case.
James McKenzie
L-3 GSI
________________________________
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Guillermo Alfredo Torres Barron
Sent: Monday, October 30, 2006 5:45 PM
To: [email protected]
Subject: Re: QUESTION: MENU - NOT LIKE
**
I use this qualification
$GROUPS$ LIKE "%Administrator%"
Work good ;)
A question, somebady I said me that if I can use LIKE in a Run if quealification I do a FULL SCAN over database, It is true?
Thanks in advance
__20060125_______________________This posting was submitted with HTML in it___
