Hi Russel

If you use SET ENGINEBEHAVIOR 70 you can work in VFP8 without change your sqlcode. Usually the mayor problem with sql7 to migrate to sql8 are the following sql commands: distinct, union, group by, having and like, but with enginebehavior set to 70 you solve the problem.
But it's a good idea that you change those sql sentences to the new sintaxis, because is more compatible with sqlserver sql commands, and it would be very easy that you migrate to VFP 9.0 in the future.When you finished the conversion change the set enginebehavior to 80 again, but meanwhile you can work without problems.

Regards

Carlos