rastafaray
asked on
SQL update statement to replace txt string with a non-printable line-break character
SQL update statement to replace txt string with a non-printable line-break character
we would like to update all '<BR>' entries in a field with a non-printable line-break character
thank you.
we would like to update all '<BR>' entries in a field with a non-printable line-break character
thank you.
update table set column = REPLACE(column,'<BR>','\r\ n') where <your criteria>
ASKER
that didnt work!
we ended up with "HELLO\r\nTEXT" instead of "HELLO<BR>TEXT"
we are looking for
"HELLO
TEXT"
we ended up with "HELLO\r\nTEXT" instead of "HELLO<BR>TEXT"
we are looking for
"HELLO
TEXT"
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.