Running a 'Distinct' query returns some results TWICE !?

[Rob De Marco]

Hi

I've spent hours trying to find out why a perfectly simple query that uses the 'distinct' keyword such as:

Select distinct(field1)
From tablename;

works fine based on eg. field1, but when running it on eg. field2 in the very same table, it returns 2 results (yet, only on some words!). Pls see example of result below:

Eg of a 'faulty' result:
_________
Field2
----------
Andrews
Backer
Backer
Collins
Durrmans
Eisner
Eisner
etc......

I have tripple checked the spelling (it is the same), I have copied the table into a new one, I have backed it up and restored and I've run repair utilities just in case. But no fix...
Any thoughts would be greatly appreciated :-)
Thanks

Rob