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.