I inherited an SQL statement

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

where lcFilter = "Where (neSigOpt = 2 or neSigOpt .LessThan. 2) AND IsActive"

What we're seeing is:

Lname, Fname        neSigOpt (Not Diplayed)             neSigOpt Translation (displayed)
AA, Abel                     3                                 PIN
BB, Betty                    3                                 PIN
CC, Cain                     3                                 PIN
...                          3                                 PIN
AA, Andy                     2                                 Fingerprint
...
ZZ,Zed                       2                                 Fingerprint
AA, Aaron                    1                                 Not Authorized
..
XX, Xena                     1                                 Not Authorized
AA, Annie                 (Blank)                              Not Authorized
...

I've tried manipulating the neSigOpt field with iif(empty(neSigOpt),1,neSigOpt) as neSigOpt - but it seems to make no difference.

What I need is AA, Annie to follow AA, Aaron, etc

Suggestions?