Subject Re: Why "Like" , "=" return diffent number records?
Author Kadee
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