>In vfp 6, Can you "select sum(price) from thisdbf where x=y" and have the result go to a var?

Not a SQL statement, but you can get that result with CALCULATE:

Calculate Sum(price) For x=y To memvar

Works on the current work area.