Hi,

I'm obviously losing my marbles somewhere, but I seem to have the
strangest problem.

Using a 2.0.1 remote server on XP, this query works fine.

SELECT c.CONTACTID, c.NAME, c.COMPANYNAME, c.ADDRESS1, c.ADDRESS2,
c.ADDRESS3, c.ADDRESS4, c.POSTCODE, c.WORKPHONE, c.WORKEXTENSION,
c.MOBILEPHONE, c.EMAILNAME
FROM Contacts AS c
WHERE (((Exists (select * from Contacts c2
where c2.Name = c.Name
and c2.CompanyName = c.CompanyName
and NOT (c2.ContactID = c.ContactID)))<>False))
ORDER BY 2, 1;

Using the same query on a remote 2.0.3 server, latest release, the query
stalls and returns no data. The really weird thing is, it DOESN'T cauase
a problem on a local 2.0.3 server, only on remote.

Anybody any clues as to where I should start?

Thanks in advance,

Rob Davis