Hello again 🙂 Some of them are hardcoded strings and others are coming from the database. However, I think I have found at least a temporary fix. I am testing it now. I have a new variable also nVarchar(max) and I have split the beginning of the string that was being truncated, the first part just short of the 4000 characters is going into the 1st variable and the rest of it is going into the 2nd variable, I am then concatenating those 2 variables, and updating the table and it is being checked now. However, I still find that a little weird. And would still love to know how I could do this without the second variable. Basically, set @EmailMessage1 = 'first 3500 or so chars' set @EmailMessage2 = 'the rest of the 10,000 character string' set @EmailMessage1 = @EmailMessage1 + @EmailMessage2, update table. I love SQL