I'm trying to truncate results after 32,759 characters, since that is the character limit in excel and that's where my results will be pasted. 

Two method I've tried so far:

```
CONVERT(varchar(max), substring(comment,1,37259)) as [Comment]
CONVERT(varchar(max), ( substring(comment,1,8000) + substring(comment,8001,16000)...)) as [comment]

```

Edit: It seems like the data isn't getting into the varchar(max) as it's returning results with only 8000 characters. This is part of a select statement. I have no problem getting results over 32759 characters, it's just that they run into the next line when pasting into excel - which is why I'm trying to truncate.