Re: Supressing spaces in a field

Use the replace sql function

select replace(phone_num, ' ') from ...

where "phone_num" is the name of the column...

replace allows for a 3rd parameter which is the replacement string, if you omit it, however, it will simply remove the spaces.

For more information see the documentation on the replace function in the oracle sql manual.

Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free!
http://www.keen.com Received on Mon Aug 14 2000 - 21:06:39 CDT