>when I browsed cur_temp1 it was the whole table. What is that about? Is this something with rushmore? Or did I just screw something up? :)

A little addition to George's answer, sometimes, if applicable, SQL doens't create a temporary cursor where it can just use a filtered version of the orginal table. NOFILTER will gaurantee this doens't happen. So, when you ysed DBF(), it may have just used your base table and then added the filter, thus getting you all the records in the base tbale.