It is hard to see what is going on if there is no repro script is posted. In
any case, this is not expected since a direct simple query with a WHERE
clause should always give you a subset of the resultset the one without a
WHERE clause produces. BTW, which interface are you using? Is it EM or QA?
Or is this an Access interface which is linked to SQL Server?
( Please reply to newsgroups only )