Naomi,

I suppose Doris needs the neSigOpt field in her cursor for some kind of future processing, as for this particular query she could do with only:

Select Lname, ;
			 fname, ;
			 (999 - Nvl(neSigOpt,0)) as nnIndex ,;
			 Padr(confirmType(neSigOpt, lPin,lFingerReg),30) as Confdata ; 
from ther into cursor temp order by nnIndex, lName, fname

which would give her (Isuppose) a sorting group as needed.

Regards,

Koen