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