I'm sure the CrLf is in there, it's just not visible based ont he tools you are using;

Proof: you said it looks like this:

two lines means there is a CrLf there.

I've used this code to strip HTML out.

try it on one of your columns, view it in TextMode, and confirm the results span more than one line;

if it does not, you might want to repalce

tags with CHAR(13) +CHAR(10), which will make it plain text readable for both Win and Unix(which uses just CHAR(10) i believe for a new line)

--===== Replace all HTML tags with nothing

WHILE CHARINDEX(' CHARINDEX('<',@HTMLText)

SELECT @HTMLText = STUFF(@HTMLText,

CHARINDEX('<',@HTMLText),

CHARINDEX('>',@HTMLText)-CHARINDEX('<',@HTMLText)+1,

'')