I have a table with some data in a VARCHAR2 column that contains linefeed characters.
These were entered by users pressing 'return' when in a web text box.
I want to get rid of these using the REPLACE function, but I'm having trouble identifying them.
If I have the following sample data:
CREATE TABLE test (text VARCHAR2(100));
INSERT INTO test VALUES ('Sample Text one line');
INSERT INTO test VALUES (
'Sample Text '||chr(10)||
'two lines');
INSERT INTO test VALUES (
'Sample '||chr(10)||
'Text '||chr(10)||
'three lines');
SELECT * FROM test;
Then I'd like to identify them using something like...
SELECT text FROM test WHERE text LIKE '%CHR(10)%';
but that obviously doesn't work.
How can I find them?
Thanks.