>HA!
>That is something new to me!
>This is not written anywhere, or at least I couldn't found it.
>It works even with SET ENGINEBEHAVIOR 70:
>

>SET ENGINEBEHAVIOR 70
>
>
>CREATE CURSOR Table1 (Aid  I, AAGcy I)
>CREATE CURSOR Table2 (bidv I, bvalue C(20))
>INSERT INTO Table1 VALUES (1, 1)
>INSERT INTO Table1 VALUES (1, 2)
>
>INSERT INTO Table2 VALUES (2, [aaaaaaaa])
>
>
>select aid, aagcy, NVL(bvalue,'a') as bvalue ;
>    from table1 ;
>    left join table2 on (table2.bidv = table1.aid);
>ORDER BY Table1.Aid;
>into cursor tempo readwrite
>WAIT WINDOW LEN(tempo.bvalue)
>BROWSE NORMAL
>

When the calculated field length is calculated based on a first matching record and when it is not?