From: jmose@mapson.attglobal.net   
      
   Anders   
      
   >I'm not sure but will a search like that ever be able to take advantage   
   of   
   >an index?   
      
   But, it will only go through all the rows of the index, not the base table.   
    At one client, Customer.db is 650kb but Customer.XG1 is only 66kb.  10 times   
   smaller should be 10 times faster, or more since I'm not getting network   
   retries.   
      
      
   >If your search had been for "Jim.." it would have been a different story   
      
      
   Right, but I didn't want to force my users to enter data a specific way -   
   'Jim Moseley' or 'Moseley, Jim' or whatever.  Also, it helps them if they   
   can't remember how to spell, ie. 'McGuire' 'Maguire' 'MacGuire' can all be   
   found with '..guire..'.   
      
   Thanks,   
   Jim Moseley   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)