>>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.

Hey George,
I knew I would be caught by my English:)
Cetin