Hello, I am migrating some data from one table to another table. One of the columns in both tables is for phone numbers. In the original table its a varchar(50) and in the other its a varchar(20). When I try to do the migration, I am getting an error when there is a phone number longer than 20 chars. Is there a way to truncate the ones longer than 20 using t-sql? Thanks in advance.
matt
matt