CarName Seq Rec
SELECT InsCarr.CarName FROM InsCarr JOIN Covr ON InsCarr.InsCarr=Covr.cvCarr ; WHERE Covr.Pat_No=Patient.PtPn AND CvPS=InsuranceLevel AND ! DELETED() ; ORDER BY 1 INTO CURSOR CarrierList SELECT PADL( Seq_Num, 4, '0' ) AS Seq, RECNO() AS Rec FROM covr WITH (BUFFERING=.T.) ; WHERE Pat_No=Patient.PtPn AND CvPS=InsuranceLevel AND ! DELETED() ; ORDER BY 1 INTO CURSOR SequenceList