:wtf: Sorry, what a ridiculous question. You either take the defaults (which will show you are the time how much space) or you set your own sizes. Bob Ashfield Consultants Ltd

You can do this without a script. INSERT INTO table2 (field1, field2, ..., fieldn) SELECT ..... FROM table1 Deja View - the feeling that you've seen this post before. My blog | My articles