Hi Steve,

One more option,

* One Student 
iStudentIdMin = iStudentId
iStudentIdMax = iStudentId
* All Students
iStudentIdMin = 1
iStudentIdMax = 2^31-1

WHERE courses.iid = iCourseId AND students.iid BETWEEN iStudentIdMin AND iStudentIdMax

>Good question Sergey. This cursor is going to be used as the controlsource for a variety of reports. One of the options presented to the user is to print a report for an individual student or all of the students in the course. To accomplish this, I want to add another expression to the WHERE clause...
>.
>.
>WHERE courses.iid = iCourseId AND students.iid = iStudentId
>.
>.
>If wildcards are an option, I have the flexibility of using the cursor for both situations; one dataenvironment, one cursor to maintain for more than a dozen reports.
>
>Thanks!
>