Hi Sergey;
thanks, your solution work.

I translate it (for all intersted in) according to may sample from message.

SELECT;
 Test1.c1, Test2.c2 AS max_code;
 FROM Test1 ;
 LEFT OUTER JOIN Test2 ;
 ON Test1.c1=ALLTRIM(Test2.c2);
 OR 'X'=ALLTRIM(Test2.c2)

But now I'm in trouble to understand why. Also I do

SELECT;
 Test1.c1, Test2.c2 AS max_code,;
 Test1.c1=ALLTRIM(Test2.c2),'X'=ALLTRIM(Test2.c2);
 FROM Test1 ;
 LEFT OUTER JOIN Test2 ;
 ON Test1.c1=ALLTRIM(Test2.c2);
 OR 'X'=ALLTRIM(Test2.c2)

As supposed 'X'=ALLTRIM(Test2.c2) is always .F. except for "grau" and "will".

Following that I try

SELECT;
 Test1.c1, Test2.c2 AS max_code,;
 Test1.c1=ALLTRIM(Test2.c2),'X'=ALLTRIM(Test2.c2);
 FROM Test1 ;
 LEFT OUTER JOIN Test2 ;
 ON Test1.c1=ALLTRIM(Test2.c2)
* ;
* OR 'X'=ALLTRIM(Test2.c2)

- all from Tests is .NULL. again.
The OR 'X'=ALLTRIM(Test2.c2) changes something in the join, but why?

A play a bit around OR LEN(Test2.c2)=-1 is as fine as OR 'X'=ALLTRIM(Test2.c2).
Thats weird.

I wish everybody a nice rest of the day - a have an encounter with my cushion now.
See you tomorrow.

Agnes