[AccessD] compare record fields

Wed Oct 27 05:59:27 CDT 2004

Hi Pedro

> i have a table in which i would compare two fields in one record with each other.
> The result must be the record where one of the values don't match with one another.

> fieldA    fieldB  and several other fields
> 00123     00123
> 02345     02345
> 06789     06689

> result

> fieldA   fieldB  and several other fields
> 06789    06689

That could be:

  SELECT
    *
  FROM
    tblTable
  WHERE
    FieldA<>FieldB;

/gustav