SQL
html 줄바꿈 처리
우혁이 아빠
2011. 4. 5. 13:44
select REPLACE(REPLACE(news_contents, chr(10), ''), chr(13), '<br/>')
from ENG_CONTACT_NEWS
where news_sq_no = 1782;
select REPLACE(REPLACE(news_contents, chr(13), ''), chr(10), '<br/>')
from ENG_CONTACT_NEWS
where news_sq_no = 1782;
from ENG_CONTACT_NEWS
where news_sq_no = 1782;