SEO

#1 (**permalink**) 04-20-2008, 03:33 PM

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

#2 (**permalink**) 04-20-2008, 03:33 PM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Replace a carriage return in a text field