Re: Removing blank spaces
Roque Daudt <[email protected]>
| Newsgroups | gmane.comp.db.oracle.devel |
|---|---|
| Message-ID | <LYRIS-1796914-803432-2002.12.16-06.25.08--gcdod-oracle#[email protected]> |
If it is OK to remove ALL spaces in the string then you can try the
REPLACE function, like in
replace('ALLTACINCORP .000000409', ' ', null)
Roque Daudt
--- "Bandiatmakur, Ravi" <[email protected]> wrote:
> Hi all...
>
> I have the following values in my database..with spaces padded in the
> middle....
>
> ALLTACINCORP .000000407
> ALLTACINCORP .000000408
> INTEGRITYMED .1
> ALLTACINCORP .000000409
> ALLTACINCORP .000000410
> ALLTACINCORP .000000385
> ALLTACINCORP .000000411
> ALLTACINCORP .000000412
> ALLTACINCORP .000000413
>
> What is the effecient way of removing the blank spaces in these
> values...?
> The only solution that comes to my mind is to findout the ascii value
> of
> blank space and read the string character by character
> and append it to another string if it is not a blank space.....
> Any other effecient solution will be appreciated.
>
> Thanks in advance
>
> Ravi.
>
>
> ---
> Change your mail options at http://p2p.wrox.com/manager.asp or
> to unsubscribe send a blank email to
%%email.unsub%%.
__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
---
Change your mail options at http://p2p.wrox.com/manager.asp or
to unsubscribe send a blank email to [email protected].