Its because he is executing dynamic sql. I've only ever had this problem when executing dynamic sql with large statements. for some reason, it truncates to the shorter...

Shoot, I wanted to say it was because you spelled Widget wrong 😛

make sure that the variables you are concatenating with are all varchar(8000). Otherwise, it will truncate to the shorter one (the varchar(4000)) even though it is larger in size.

The final variable will truncate to the shorter variables being used to build the string. you have to make all 3 a varchar(8000) for this to work.