INFORMIX SQL - Inserting caracter LF

It=B4s possible to insert a LF character or another non-printable = character using insert into table (literal) on a varchar column. Something like this? insert into tablename values ('xxx^Jxxx') I cannot use bind variables. =20 Jairo Gubler=20 Analista de Sistemas - APC=20 D=CDGITRO TECNOLOGIA=20 E-mail: jairo.gubler@digitro.com.br=20 Fone:(48) 281 7213=20 Fax:(48) 281 7299=20 Site:www.digitro.com.br=20

Version information? There's a stored procedure - ifx_newline() IIRC - which permits you to write strings with newlines in them. Then write your string with a newline in it. If LF != NL, then simply put the LF into the string... -- Jonathan Leffler (jleffler@us.ibm.com) STSM, Informix Database Engineering, IBM Data Management 4100 Bohannon Drive, Menlo Park, CA 94025 Tel: +1 650-926-6921 Tie-Line: 630-6921 "I don't suffer from insanity; I enjoy every minute of it!" forum.subscriber@iiug.org wrote on 09/23/2004 11:03:36 AM: > It=B4s possible to insert a LF character or another non-printable = > character using insert into table (literal) on a varchar column. > > Something like this? > insert into tablename values ('xxx^Jxxx')> > > I cannot use bind variables. > =20 > Jairo Gubler=20 > Analista de Sistemas - APC=20 > > D=CDGITRO TECNOLOGIA=20 > E-mail: jairo.gubler@digitro.com.br=20 > Fone:(48) 281 7213=20 > Fax:(48) 281 7299=20 > Site:www.digitro.com.br=20 > >