That was my first thought too, but I can change the query string to "Ralph" and it still does a sequential scan of the table, returning no rows.
-- Jeffrey Kain [email protected] > On Sep 12, 2017, at 11:26 AM, Spencer Hinsdale via 4D_Tech > <[email protected]> wrote: > > isn't there some trick to use a character code instead of at? > > and does the "beginning and end" pref possibly apply? ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************

