It's funny, using this with another column of similar data works perfectly, if I stack new line and double new line char/nchar variations in a VALUES construct and use that for positions, but on the column I was originally trying it on, it goes nowhere. I may work on it later, or just stick with my alternate solution using your idea in its place. There's just so much going on in the original column it's hard to account for all the varations. It's like entire email threads :alien:

DECLARE @NEWLINE CHAR(2) = CHAR(13) + CHAR(10)--+ CHAR(13) + CHAR(10)

DECLARE @DOUBLENEWLINE CHAR(4) = CHAR(13) + CHAR(10) + CHAR(13) + CHAR(10)

DECLARE @NEWLINE_N NCHAR(2) = NCHAR(13) + NCHAR(10)--+ CHAR(13) + CHAR(10)

DECLARE @DOUBLENEWLINE_N NCHAR(4) = NCHAR(13) + NCHAR(10) + NCHAR(13) + NCHAR(10)

Thanks