>The foolowing command Iam using in SQl-Server 2005 directly. If I want to use it from as front end VFP9
>How to use it?
>
>insert into emp_master (emp_id,fir_name,passport_no) select johu1.ep_id,johu1.fr_name,johu1.pass_p from johu1 where not exists
>(select 1 from emp_master where RTRIM(emp_id)=RTRIM(johu1.ep_id))"
>
>Thanks & Regards
>
>PARAMU

You can use SPT for this.