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