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

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