It converts a logical into verbage. In other words, if PIN is marked 'true', ConfData comes out as 'PIN'



>Hi Dorris,
>
>What ConfirmType UDF is about? What exactly does it do and does it change any fields?
>
>>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?