How to Replace one or more instances of a substring
Posted: 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.
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.