Check to make sure the "PE" is the same "PE" does not == "Pe" Use the UPPER() or LOWER() also something Like
WHERE ALLTRIM(UPPER((DISTRC.DISTRICT)) == "PE"
Ron
>What's really wierd is that it finds some but not other instances of the district. I did a select distinct and the only "PE" one in there is "PE" ... only one record returned for the select distinct. So if it found 15 of them, and they were all the same, wonder why it didn't find all of them. Really strange.