>In some cases VFP will use the "SORTWORK" specification. That may be how this happens.
Jim, that was it! We pointed SORTWORK to an alternate local drive and the SQL query worked. We no longer get the out of disk space error. However, were still at a lost to explain why one machine with 850 MB whould give out of disk space.
BTW, I hope this works for Eric, because you deserve some stars.
Thanks!
--Paul