COPY TABLE users AS usersCopy WHERE UserId > 500 ?

I must extract rows (with criteria) from a table with a few millions of rows in MS SQL 2000
Is there a way to COPY a table ?
if so is there a way to COPY it in a more selective way ?
something like :
COPY TABLE users AS usersCopy WHERE UserId > 500
thank youselect * into usersCopy from Users where UserId >500|||that is what I call 100% GENIAL !!!

thanks 1000 ton !