David,

See answers inline.

>I'm using VFP9 to communicate with SQLServer database, using SQLEXEC(). I need to know the corresponding SQL commands for a few basic VFP commands:
>
>1) REPLACE table1.field1 WITH "HELLO" FOR "FRANCE" $ table1.field2

UPDATE Table1 set field1 = 'HELLO' where Field2 like '%FRANCE%'

>
>2) REPLACE table1.field3 WITH table2.field4 for table1.field5 = table2.field6
>

UPDATE T1 set field3 = T2.Field4 from Table1 T1 inner join Table2 T2 on T1.field5 = T2.field6

>3) COUNT TO x FOR table1.field7 = "JOE"

select count(*) from Table1 where Field7 = 'JOE'

See also

http://www.w3schools.com/sql/default.asp

and

http://fox.wikis.com/wc.dll?Wiki~VFPSQL-TSQL-Mapping