How to Replace one or more instances of a substring

Apotluri · Post by **Apotluri** » Fri Aug 29, 2008 10:25 am

Hi all, I have a CHAR(10) field with a value of 123-456789 and I have to map this to an output field of CHAR(9) without the '-', meaning populate the outpur field with 123456789. In server, we can do it using Change or Ereplace, but how to get this done in Parallel.

Help is appreciated.
Now, am I going to get few replies as "did u search", I truly did , but did not find the answer, I found a few discussions though.

Thanks, as always.

mikegohl · Post by **mikegohl** » Fri Aug 29, 2008 10:48 am

The convert functions should work for that.

Apotluri · Post by **Apotluri** » Fri Aug 29, 2008 11:18 am

Isn't Convert, a server function?

Can you give me the usage please, if it is parallel.

Apotluri · Post by **Apotluri** » Fri Aug 29, 2008 11:29 am

sorry, I got it.!