[AccessD] Query Grid - Exact Match

Tony Septav iggy at nanaimo.ark.com
Mon Jan 5 10:39:30 CST 2009


Hey All
Just wondering if there is an easy way using the query grid to find the 
exact word only in a string in a text field. I have done it, but I am 
using instr(), ASC() tests, etc. to pull an exact match. Just thinking 
there must be an easier way.
Example find exact word Time
Text
1. The time is 9 o'clock
2. The timer has been set
3. Please enter Time/Day/Month
4. Please enter Time&Day&Month
5. Time is on your side
6. All timesheets required by 4 oclock
7. Please enter Day/Month/Time
8. Last recorder time9 PM
9. Please enter TimeandDay
10. Please set the timertoff

Would like only records 1,3,4,5,7 and 8 to be displayed and my query 
currently does that.  9 (like to get) and 10(would be punted) can be 
possibly be done with some  tweaking, but kind of messy.
 



More information about the AccessD mailing list