2012. 9. 6. 17:58
개행문자 치환쿼리
SELECT delivery_no
, REPLACE(delivery_memo, char(13) + char(10), '\r\n') AS [delivery_memo]
, REPLACE(CONVERT(varchar(MAX), delivery_memo), char(13) + char(10), '<br />') AS [delivery_memo]
FROM delivery_setup
WHERE delivery_no = 9
출처 - 본인