Hi Jim, Have you ever tried the sqlite fts virtual table? It's specifically designed for text searching and is lightening fast. Certainly an extra step load stuff into a sneak but might be worth a look.
Pete lcSQL Software On Mar 15, 2014 4:25 PM, "Jim Hurley" <jhurley0...@sbcglobal.net> wrote: > Just thought of a situation I didn't deal with. The apostrophe is tricky. > > In doing a word search, you would want to kept the apostrophe in the word > "don't" but probably not in "Howard's best friend is his dog." "Howard's" > should appear in the found sentence but not in the word search, i.e. If you > searched for sentences in which "Howard" appeared, you would want to find > "Howard's best...." > > > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
