>Is there an Insert Select statement in Visual FoxPro 6. If there is can you let me know.
No.
The only way to emulate it in VFP is with a SCAN.. ENDSCAN loop or a conditional REPLACE.