Hi Aleksey,

Thank you very much for helping me!

I´ve modifyed the code you posted:

CREATE CURSOR taba (id C(4), field1 C(6), field2 C(1))
INSERT INTO taba values("0101","desc 1"," ")
INSERT INTO taba values("0201","desc 2","X")

CREATE CURSOR tabb (id C(6), field1 C(1))
INSERT INTO tabb values("010101","1")
INSERT INTO tabb values("010102","2")
INSERT INTO tabb values("010103","3")
INSERT INTO tabb values("020101","1")
INSERT INTO tabb values("020102","2")
INSERT INTO tabb values("020103","3")

select * from tabb left join taba on left(tabb.id,4)=taba.id where not empty(taba.field2) INTO CURSOR res

this code produces different results in VFP8 and VFP9.