>Naomi,
>
>I suppose Doris needs the neSigOpt field in her cursor for some kind of future processing, as for this particular query she could do with only:
>
>

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

>
>which would give her (Isuppose) a sorting group as needed.
>
>Regards,
>
>Koen

Yes, looks like you're right, though I didn't read this thread very closely and not sure what exactly is the original problem.