Re: Non-printable sign

EXECUTE PROCEDURE IFX_ALLOW_NEWLINE('T'); SELECT REPLACE(varchar-column, ' ', ' '), ... Regards, Doug Lawry "DeMi" <michal.demyda@gmail.com> wrote in message news:3cd892c4-5ecc-4fdf-9c7a-925377754dfe@t54g2000hsg.googlegroups.com... > Hello, > > I have problem with replacing non-printable 'new line' sign (^J) to > null. Actually, I don't know if Informix provides function like > Oracle's ord() or ascii() which would be helpful. > My task is to unload rows from sql query into file with default > delimiter '|'. It is very important that each record is written in one > separate line. However, it happens that one field can contain the 'new > line' sign. In this case my row is split into two lines which is not > allowed. The interested field is varchar type. > > Does anybody solved this kind of problem and how? > > Best regards > Michal Demyda