>i want to translate the followng command fo sql server to vfp
>
>SELECT @ing_fon =SUM(mont2)FROM PLPLFMOV AS MOV JOIN PLPLFTAB AS TAB
>ON mov.concep = tab.concep
>WHERE cod_emple = '092754' AND LEFT(MOV.CONCEP,1)='1' AND SUBSTRING(tab.tab_dscto,1,1) = 'F'
>
>how can i do this
>thank you

While Dave and Cetin have already given you the information you need, I want to add the following.

It isn't exactly true that you can't use a SELECT statement in VFP to assign a variable a value. You can always use the INTO ARRAY myarray clause.