>

>LPARAMETERS lcToMatch, lcChoice1, lcChoice2, lcChoice3, lcAnswer1, lcAnswer2, lcAnswer3
>>
>>DO CASE
>>   CASE lcToMatch = lcChoice1
>>      RETURN lcAnswer1
>>   CASE lcToMatch = lcChoice2
>>      RETURN lcAnswer2
>>   CASE lcToMatch = lcChoice3
>>      RETURN lcAnswer3
>>ENDCASE
>>

>
>
>I'd suggest putting an
>

   OTHERWISE
>      RETURN SPACE(12)  && Or whatever

>
>in that CASE statement, just in case....

Ed R. Suggested that, too. It worked, which showed me that the SQL was IIIFing records that didn't match my WHERE clause. Theoretically, there never should have been an otherwise case.

Thanks,

-Michelle