text string overflow

[Aneet]

Hi If a text string that is input in a column is larger than the field length of the column, is there any way we can set up preferences that will either discard the rest of the of the string or create an error.
Thanks

 

[tlbroadbent]

SQL 7 and 2000 will fail on inserts and updates the try to put more data in the column than the column will hold - string or binary data. Previous versions simply truncated the data and proceeded as though everything was fine. Terry

http://members.home.net/tlbroadbent/sqlarticles.htm

"I shall try to correct errors when shown to be errors, and I shall adopt new views so fast as they shall appear to be true views." - Abraham Lincoln