Help with replace()

[SkyMasterBRA]

I´d like to do this

replace(ps_cnt_txt_summary,'>','>' + CHAR(10) + CHAR(13))

where ps_cnt_txt_summary is a table column...is there any way to do this?

The command i need to do is something like this:

update ps_cnt_content set ps_cnt_txt_summary = replace(ps_cnt_txt_summary,'>','>' + CHAR(10) + CHAR(13))

Thanks in advance!

 

[tlbroadbent]

You can use the Update statement you posted if you have SQL 7 or higher and you are updating a CHAR, VARCHAR, NCHAR or NVARCHAR column. The REPLACE function was introduced to T-SQL in SQL 7. Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

If you want to get the best answer for your question read faq183-874.