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?