Replace a carriage return in a text field

Posted in 2007

jared.hanks@gmail.com — 10 May 2007 18:05:50 -0700 — source: Usenet: comp.databases.informix

Hello, I need to remove carriage returns in a text field. Does anyone know how to do this? I've tried the following: update item_table Set long_description = replace(long_description,"~r"," ") where inv_id = "130539"; and I get the following error: "674: Routine (replace) can not be resolved." I've also tried: Update items_table Set long_description = replace(replace(long_description, char(10),char(13)),char(13),' ') where inv_id = "130539"; and I get the following error: "674: Routine (char) can not be resolved." I tried looking at the manual but couldn't figure it out. Any help is appreciated. Thanks, Jared

↪ replying to jared.hanks@gmail.com

Ashish Singhal — Fri, 11 May 2007 13:58:18 +0530 — source: Usenet: comp.databases.informix

Hi, I am very new to informix, wants to know dose the connect by prior clause will work with IDS. if not then is there anything similar to that. Regards, Ashish