Path: utzoo!attcan!uunet!husc6!uwvax!rutgers!iuvax!silver!starry
From: starry@silver.bacs.indiana.edu
Newsgroups: comp.sys.ibm.pc
Subject: Re: dBase tricky INDEXing question...
Message-ID: <15000053@silver>
Date: 24 May 88 00:26:00 GMT
References: <529@etn-rad.UUCP>
Organization: Indiana University BACS, Bloomington
Lines: 18
Nf-ID: #R:etn-rad.UUCP:-52900:silver:15000053:000:617
Nf-From: silver.bacs.indiana.edu!starry    May 23 19:26:00 1988



Here is the solution that I came up with that works on my test
data.

INDEX ON STR(account,4)+SUBSTR(DTOC(date_field),7,2)+;
     SUBSTR(DTOC(date_field),4,2)+SUBSTR(DTOC(date_field),1,2)

The STR(account,4) limits the width of the field to 4 if you don't do 
this you will get leading blanks.  But if you LTRIM you will only get
7 significant characters.
   Please tell me if this works for you.

                 Joseph J. Starry
                 Indiana University
                 Sociology and Cyclotron PC Consultant
                 starry@silver.bacs.indiana.edu
                 starry@gold.bacs.indiana.edu