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

I haven't tested but I would expect the regexp datablade to do this as well Doug Lawry wrote: > Not so, Art. You can use the built-in procedure IFX_ALLOW_NEWLINE, demonstrated > as follows: > > CREATE TEMP TABLE test_table (test_column VARCHAR(255));> > EXECUTE PROCEDURE IFX_ALLOW_NEWLINE('T');> > INSERT INTO test_table VALUES ('a> b'); > > SELECT * FROM test_table;> > UPDATE test_table > SET test_column = REPLACE(test_column, ' > ', ' ') > WHERE test_column LIKE '% > %'; > > SELECT * FROM test_table;> > Jason: use the REPLACE function in an UPDATE statement as shown above to fix > your data. > -- Paul Watson # Oninit Ltd # Growing old is mandatory Tel: +44 1436 672201 # Growing up is optional Fax: +44 1436 678693 # Mob: +44 7818 003457 # www.oninit.com #