Greetings Jim - see my reply below!
sorry to waste your bandwidth!

>
>>between
>>CREATE SQL VIEW CQRY AS SELECT * FROM CONTACT!CONTACTS WHERE TOWN='NEWPORT'
>>which returns no records from a given database
>>
>>and
>>
>>SELECT * FROM CONTACT!CONTACTS WHERE TOWN='NEWPORT' INTO DBF 'CQRY'
>>
>>which returns 106 matches from the same database?