SELECT LName, FName, Mi, ThID, iif(empty(neSigOpt),1,neSigOpt), lPin, lFingerReg, ; PADR(ConfirmType(neSigOpt, lPin, lFingerReg), 30) AS ConfData, isactive, lOverride ; FROM Ther ; &lcFilter ; INTO CURSOR SigTypeR; ORDER BY isActive, 4 DESC, 8, LName, FName, Mi, ThID