[AccessD] Query Grid - Exact Match

Tony,
 
Your examples below almost seem like you are trying to account for typo's?
 
...or did I miss something?
 
 
Mark

----------------------------------------
> Date: Mon, 5 Jan 2009 08:39:30 -0800
> From: iggy at nanaimo.ark.com
> To: accessd at databaseadvisors.com
> Subject: [AccessD] Query Grid - Exact Match
>
> 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.
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
_________________________________________________________________
Send e-mail anywhere. No map, no compass.
http://windowslive.com/oneline/hotmail?ocid=TXT_TAGLM_WL_hotmail_acq_anywhere_122008