Doug,

Look at SET ANSI and SET EXACT. Both are scoped to the current datasession.

Try some testing by selecting the fields separately and then the concatenated version and and a logical field saying whethere they are equal.

Which gives you the recordset you want?


>JOIN services_for_authorization ON ;
>STR (authorization_tracking.facility) + ;
>authorization_tracking.patid + authorization_tracking.aut_link== ;
>STR(services_for_authorization.facility) + ;
>services_for_authorization.patid + ;
>services_for_authorization.aut_link ;
>
>-- Lists 5525 records
>
>JOIN services_for_authorization ON ;
>authorization_tracking.facility=services_for_authorization.facility ;
>and authorization_tracking.patid=services_for_authorization.patid ;
>and ;
>authorization_tracking.aut_link=services_for_authorization.aut_link ;
>
>-- List 28333 Records