Terry u asked me if they make a mistake do they have to delete erroneous record

I had this in valid statement, originally reflected my choice of numerical type, as u can see I adopted character and also decided to increase field length.

***********************************
Select lotno
Set Order To lotno
SEEK RIGHT(STR(mhlotno+100000000,9),8)
IF FOUND() or mhlotno=0
SET BELL TO 'c:\desales\error.WAV'

?? CHR(7)

RETURN 0
ELSE
RETURN 1
endif
***********************************

I'm happy with myself for heeding your advice,

Ciao,

Baxter