At 11:12 AM 8/13/2002, Bill Haenel wrote: >I wonder, though, is there a way to do this without specifying each field >name? It would be nice to not have to go back and edit the code much later >if I decide to add fields or something. Plus, I have many fields in this >particular table, so it would be cool to somehow shorten it. '*' wouldn't >work of course, because it would copy the entire record, and I need a new >date and id. Is there an "ALL BUT" or something? Not that I'm aware of. If you want to make it a bit easier in yourself, you could put all the column names in an array and build the SQL statement with that. --- Anthony Baratta President Keyboard Jockeys "Conformity is the refuge of the unimaginative."