RE: Removing blank spaces
"Robert Rainville" <[email protected]>
| Newsgroups | gmane.comp.db.oracle.devel |
|---|---|
| Message-ID | <LYRIS-1796914-803887-2002.12.16-16.33.50--gcdod-oracle#[email protected]> |
Use REPLACE(field,' ') -----Original Message----- From: Bandiatmakur, Ravi [mailto:[email protected]] Sent: Monday, December 16, 2002 12:32 AM To: Oracle Subject: [oracle] Removing blank spaces 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%%. --- Change your mail options at http://p2p.wrox.com/manager.asp or to unsubscribe send a blank email to [email protected].