>>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.
From Foxpro Help:
"SET ANSI Command determines how comparisons between strings of different lengths are made with the = operator in Visual FoxPro SQL commands"
--sb--