The count seems to be off. Here is my stored Query.searchvalString has to be build dynamically

PARAMETERS [searchvalString] Text ( 255 ), [DMD_DT] Long;
SELECT COUNT(*)
FROM Requisition
WHERE (DMD_DT = [DMD_DT]) AND (QTY_REQ > QTY_PEND_CANC + QTY_CANC + QTY_REJT) and [searchvalString];


Here is what I am passing in:
DMD_DT....20701
searchvalString..... (RPR_CD ='') AND (MTC_CD <>'RE')

It would be helpful to have some more information from you as to what is going wrong.

The count just comes back very high. I am calling this from a .NET app