Hi Doug,
I've been trying to figure out where to change the cFieldExpr property in the fields collection but I'm not sure where I should put the code - should I be looking at the sfgetfilter class or somewhere else?

Sandi.

>Hi Sandi.
>
>>I'm using the Query.getfilter to allow the users to enter a filter for reports. I have a few fields that need to be specially formatted in order to return a match. For example my customer # field is C(10) and if my clients are using auto numbering the number is stored as ' 1' or ' 889898'. My index is IIF(VAL(custno)=0,custno,PADL(STR(VAL(custno),10),10))
>>
>>How/where would I change the filter being built from upper(custno) to my IIF statement so it can find a match in my tables?
>
>You can change the cFieldExpr property of the field object in the fields collection. That expression is used for the filter. Normally it contains just the field name, but you can change it to any valid expression.
>
>Doug