It wasn't until recently that i paid attention to truncation during concatenation, but that's because whenever I used concatenation before it was only using short data lengths so I didn't see the effects of truncation. When I first noticed that truncation can occur I was building a Huge piece of dynamic SQL , Don't... Continue Reading →