Hi!
SELE pat_lname, pat_fname, pat_dob, pat_cdcid, recno() as cRec FROM PATIENT_VIEW WHERE ALLT(PATIENTS.PAT_LNAME) BETWEEN ALLT(THISFORM.TXT_PATLNAME.VALUE) AND ALLT(THISFORM.TXT_PATLNAME.VALUE)+'zzzzzzzzzzz' GROUP BY PAT_LNAME INTO CURSOR CURPAT
HTH.
>i have set ansi off now. still pulling more records than it should. here's the sql statement
>
>SELE pat_lname, pat_fname, pat_dob, pat_cdcid, recno() as cRec FROM PATIENT_VIEW WHERE ALLT(PATIENTS.PAT_LNAME) = ALLT(THISFORM.TXT_PATLNAME.VALUE) GROUP BY PAT_LNAME INTO CURSOR CURPAT
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.