>Terry, I hate to bother u again on this, but are u suggesting that I leave the field type as numeric, pad it for format entry and build a a character string index
>
>..or..
>
>actually change the field type to character ?
>
>
>Baxter
Baxter,
Your second option - make it a character field. To do the conversions, add a second 6 character field and do a replace all:
repl all cLotNo with right(str(nLotNo+1000000,7),6)

then remove the nLotNo field from the structure