Dear Martijn Tonies;

Thanks for your fast reply.

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

Field1 is a varchar column.

>

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

I don't think the trailing space will cause the
diffence of result.

Kadee Aon