Dear Martijn;

> What kind of columns is "Field1" - is it a CHAR or VARCHAR column?

Field1 is a varchar(10) column.

>
> Does "Field1" have values with trailing spaces?

select * from table1
where field1 ='AAA'
and field1 like '___'

recordcount = 125

select * from table1
where field1 ='AAA'
and field1 like '__________'

recordcount = 25

Thanks again;

Kadee Aon