Re: How to query up the newline (||) character in SQL editor

think you'll need to match every char[i] in your string against the ASCII representation of a newline If the ascii representation is newline, the replace that character with a space. if you have replaced any characters then update that row, you should be able to write a stored procedure to do it.