Gary, that seemed to be what I needed/wanted... Originally I was under the impression that I would be able to do an alter table because of the architecture of the system and the security... but since this is going to be a well-documented one-off script I am creating (to be used as a template on future implementations) and will be run by us as the DBA (as opposed to some of our other scripts which can be run by the client) the permissions will not be a problem. Now I just need to script the data, get the pieces in the right order, and I should be good to go.

thanks!

-tg