Greg,

SET EXACT is not the correct setting when SQL is involved - you need to SET ANSI.

Cheers,

Jim N

>I've noticed some strange sql behavior that maybe someone knows a fix for. I was getting net sales information by state and the sql was something like:
>
>select state, sum(sale) from sales group by state
>
>note: there were a few records where the state was blank and set exact was on
>
>The result of each state pulled in the sales from the blank state also. The each state was overstated by the sum of the blank state. This didn't always happen. It happened when I ran the query 2 or 3 times. If I exited foxpro and then come back in and reran the query it would work properly. Any idea of how to fix this problem
>Thanks