>Hi!
>
>In the line 07 - 13, Can I using SQL-SELECT? If yes, how change it?
>
>Thank you!
As far as I am aware, SELECT - SQL is used to select data in one pass. What you want is exactly the opposite. I would recommend using SCAN...ENDSCAN instead of DO WHILE !EOF() - I think this is internally faster and it is easier to pick out of other DO WHILE statements.