Hey Larry, I am not sure if this will do the trick, but have you tried something like this? SELECT REF_REFNO , REPLACE ( CAST ( REF_MEMO AS varchar ( 8000 )), CHAR ( 10 ), 'line feed' ) AS Line_Feeds FROM MREF WHERE CHARINDEX(CHAR(10), CAST ( REF_MEMO AS varchar ( 8000 )) )>0