Oninit cdi / Archive
Talk to an expert →

Re: How to convert carriage return to another char string in Informix

Posted in 2004

Topics: Connectivity: ESQL/C, 4GL & Embedded SQL

Jean Sagi — — source: Usenet: comp.databases.informix

Doug Lawry wrote: > Your function could be used as follows in any 4GL version: > > replace("xyz", ASCII(10), "-") > You can do that natively in 4gl? or in SQL. -- Atte, Jesus Antonio Santos Giraldo ----------------------------------- jeansagi@myrealbox.com jeansagi@netscape.net sending to informix-list

↪ replying to Jean Sagi
Doug Lawry — — source: Usenet: comp.databases.informix

Native 4GL but not SQL or SPL. You don't in fact need the brackets, for example MAIN DEFINE x CHAR(10) LET x = "ABC", ASCII 10, "DEF" DISPLAY x END MAIN produces ABC DEF Regards, Doug Lawry www.douglawry.webhop.org "Jean Sagi" <jeansagi@myrealbox.com> wrote: > Doug Lawry wrote: > > > Your function could be used as follows in any 4GL version: > > > > replace("xyz", ASCII(10), "-") > > > > You can do that natively in 4gl? or in SQL.

Glossary