Doris,

Select Lname, ;
			 fname, ;
			 ThID, ;
			 neSigOpt, ;
			 Padr(confirmType(neSigOpt, lPin,lFingerReg),30) as Confdata, ;
			 lPin, ;
			 lFingerReg, ;
			 isactive, ;
			 lOverride ;
from ther into cursor temp order by neSigOpt, lName, fname
Browse normal

wil give me the result:

LNAME FNAME NESIGOPT     CONFIRMTYPE
AA		Annie .NULL.	Not authorized
AA		Aaron   1	        Not authorized
XX		Xena	1		Not Authorized
AA		Andy	2		Fingerprint
ZZ		Zed	2	        Fingerprint
AA		Abel	3		PIN
BB		Betty	3		PIN
CC		Cain	3		PIN

however I realize my listing is not correct since you have a lcFilter (neSigOpt=2 or neSigOpt Less than 2) which I translate as

neSigOPt <= 2

and in your example required result you show Abel, Betty and Cain with neSigOpt 3, so please report back and I will try to correct

Regards,

Koen