Thanks Vlad,

it seems like I misunderstood his problem ...

Vlad

>Replace your "=" operators with "LIKE" operators in the WHERE clause.
>
>If you want to retrieve data for just one value, set the variable(s) to that value (be careful, the string value should not be trimmed).
>
>If you want all records, set the variable to "%".
>
>Unfortunately, this works only for character fields.
>
>Vlad
>
>>I am creating a PV to create a report for a school app. The user specifies the parameters as follows:
>>
>>The user must specify the Term (?vTerm). The other parameters are optional: Student Name (?vStuFKey--one student only), Level (?vLevel--all classes for that level), Level + Section (?vSection--all activities for that level+section) OR Level + Section + Activity (?vActivity--one class only). I'm having trouble with the SQL WHERE clause. Let's take the simplest example: the user wants the report for the entire Term (all classes, all students). In that case I want all the other ?v-parameters ignored:
>>
>>1. Is there a wildcard character that I can use for the other ?v-parameters so that they will be ignored or be all-inclusive?
>>
>>2. If not, how can I write the SQL to scratch where I itch?
>>
>>TIA,
>>John