Re: Converting using string

Ivan Muravyov wrote in message <373333DB.DA2CC5DA_at_dxi.com>...
>It's interesting, what are the datatypes and 'different server' database?
>
>I don't know what your data looks like, so can only advice to try:
>1. Use to_number:
>insert into ..... values to_number( my_varchar ), ....
>It accepts leading zeros and treats them OK.
>2. Use string functions 'translate' or 'replace'
>insert into ..... values replace( my_varchar, '000' ), .....
>this will replace ALL '000' combinations with empty strings (simply delete
>them).
>
>If you explain more, I think, I'll help more.
>
>Jaan.

Thanks for your assistance, but there is many more faults with the application so this was just a part of it......... Never agian taking over..............

Cheers
Aa. Received on Tue May 11 1999 - 10:24:15 CEST