I can't find anything in the help about the difference between = and ==. I'm guessing the == is "more exacting". But I can't see why I only get 15 records returned from the first statement below and I get 100 returned from the 2nd. I've alltrimmed about everything so that should take care of any wierd extra spaces or anything. I visually checked the results when I got the 100 records and they're all district = "PE" and cost center = "934".

I just don't get it? Help?????

My first statement (that produces 15 records) is :

SELECT 	DISTINCT ITEMS.ITEM_ID ;
FROM 	ITEMS, DISTRC ;
WHERE	alltrim(DISTRC.DISTRICT) == alltrim("PE") AND ;
	alltrim(DISTRC.RC) == alltrim(ITEMS.RC) AND ;
	alltrim(items.rc_cc) == ALLTRIM("934")

The second one (that produces 100 records) is:

SELECT 	DISTINCT ITEMS.ITEM_ID ;
FROM 	ITEMS, DISTRC ;
WHERE	alltrim(DISTRC.DISTRICT) = alltrim("PE") AND ;
	alltrim(DISTRC.RC) = alltrim(ITEMS.RC) AND ;
	alltrim(items.rc_cc) = ALLTRIM("934")

Being as I've alltrimmed everything, I don't understand the difference? Thanks in advance for any help.