copying rows

I have a table that stores spot info for our tape label system. I want to
be able to copy all records with a specific librarynumber back into the
same table, but with a different librarynumber.

Something similar to this (which of course does not work)

select into tblspotinfo (librarynumber) values ('6666') select spotnumber,
spottitle, isci, trt, date, timecode from tblspotinfo where librarynumber
= '9988';

Of course it does not like me overloading the select into command like
that. Is there a simple way to do this that I am just missing? I just
want to duplicate the data related to librarynumber 9988 and make the new
librarynumber 6666.

Thanks for any insight,
Walt