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.aspand
http://fox.wikis.com/wc.dll?Wiki~VFPSQL-TSQL-Mapping
If it's not broken, fix it until it is.
My Blog