Yes, you with the following
SET ANSI_WARNINGS OFF;
SET ANSI_WARNINGS ON;
It's important to remember to switch the warnings back on afterwards.
Personally, however, rather than allowing the truncation, consider using LEFT.
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does :-P
Please always remember to encapsulate your code in IFCode Markup. For example [code=sql] [/code]
to read Jeffs Guide on how to post SQL questions, and get swift and helpful answers from the community