>>>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. :)
>

Don't worry. It's not the last big long etc. thing:)