Yes, you with the following
[Code]SET ANSI_WARNINGS OFF;
--INSERT operation
SET ANSI_WARNINGS ON;[/code]
It's important to remember to switch the warnings back on afterwards.
Personally, however, rather than allowing the truncation, consider using LEFT.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk