Path: utzoo!attcan!utgpu!jarvis.csri.toronto.edu!mailrus!iuvax!cica!mr From: mr@cica.cica.indiana.edu (Michael Regoli) Newsgroups: comp.databases Subject: Re: Avoiding SET FILTER TO command Message-ID: <61@cica.cica.indiana.edu> Date: 1 Aug 89 14:47:49 GMT References: <9636@phoenix.Princeton.EDU> <472@uncmed.med.unc.edu> <104@herron.uucp> Organization: IU, Bloomington Lines: 16 jbrown@herron.uucp (Jordan Brown) writes: >The real answer is to index on the pair of fields and seek on the >concatenation. >index on last+first to lf >seek "Brown Jordan" ^^^^^^^^^^^ why is there whitespace between first and last names? is this a tab? -- michael regoli mr@cica.indiana.edu regoli@iubacs.bitnet ...rutgers!iuvax!cica!mr