Adding a line break to a string for SQL update

[Steven Berkson]

Anyone have any tips for an SQL update where I want to put a line break in a text field if there is already content in that text field.

 

I’ve tried \r\n, \\r\\n, \\n, and \n, but all I get in the textarea of the admin form is the actual characters such as \\n. It seems the characters are also being saved in the text field rather than a line break…