I understand you point about the truncation not ginving you an error -- It should.

I do some data imports from a 4GL/DBMS called "Progress" where we have the same...

Why are you using a varchar 10 instead of a datetiem field? When using a date time field, your imported data would probably have been imported correctly in the first...

If you are using a text datatype, you need to use the readtext, writetext, and updatetext

commands to use the text field.

By default, SQL only stores the first 256...