The difference is that a single = acts as specified by your EXACT setting while == demands an exact match regardless of SET EXACT.

>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.