How do I run a query to compare the data in two columns and select only the records where the data between the columns does not match?

I have a Mailing database that has a column with the street number for the physical location of a property(HOUSENO). I have another column that has the complete mail to address of the owner(MAILADDR1). (I did not design the database!) Is there anyway to pull all of the records where (HOUSENO) is not equal in whole or in part to (MAILADDR1)? An example of HOUSENO would be 11290, and an example of MAILADDR1 would be 11290 Beech Lane. I would not want this record selected.

Thanks,Start Free Trial