Greetings,I am trying to move data from one table to another, but because truncation occurs, the following statement fails. INSERT into PEBContacts (ID, firstname, lastname, address1, address2, address3, city, state, zip) SELECT ID, firstname, lastname, address1, address2, address3, town, state, zip FROM addresses
I realize this is "bad form" to truncate data and possibly lose data, but it does not matter in this case and I really want the data moved into the PEBContacts table. If any of these fields in the addresses table are over the varchar length of the columns in the PEBContacts table, it is screwy data anyway.How can I force truncation while trying to move data from the addresses table to the PEBContacts table?Or alternatively, what is a way to move data from one table to the other, using a method other than INSERT INTO and SELECT?Thanks,-ravl13
[solved] Truncating data when moving btwn tbls
Posted - 2011-09-21 : 13:48:01
