>>I've got a filtered table. I want to copy all the records that passed the filtering to another table. What's the best way to do this?
>>
>>Thanks,
>
>COPY TO ... FOR ...

So I need to repeat the filter after the for? I was hoping since it was already filtered I could get away without repeating that big long complicated thing. :)

Thanks,