THANK YOU SO VERY MUCH! Your answers are extremely helpful and the links are perfect.
>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