Option to truncate data instead of raising error

Say, I have a table that has a column with a size of varchar(200).  Sometimes we get data that exceeds this length, but we don't want to raise an error.  We would rather just take the data we can and truncate the rest.  Can we have an option in Centerprise that let's us do that?


Please sign in to leave a comment.