>I am trying to understand what setting is different !
>
>With my Office development computer, the result of a filtered view contains all records meeting the filter requirement. i.e. with a filter of the project ID of say '000504', the result contains all records containing 000504.01, 000504.02 etc .
>
>With my Clients computer, zero records are obtained. and it is necessary to identify the all possible proj_id combinations within the SQL query filter variable.
>
>Any ideas
>
>Peter F Lee
What's your clients setting for SET EXACT? Sounds like it's different from yours.