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.