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

Well your English in a lot better than my Turkish.:-)

Seriously, I missed the reference to the array in your code sample. Sorry...