Re: Removing blank spaces from a column ?

I assume you mean the data in the columns. There isn't a command I know off.

But you can read the column into a record and then trim it, then update.

In article <39DB51C8.5EA44A9D_at_aom.bt.co.uk>,   Matt <zagnimp_at_aom.bt.co.uk> wrote:
> Hi
>
> Is there a function/procedure plsql command
> for removing blank spaces from a column ?
>
> ie I would like to remove all the blank spaces
> from the following column...
>
> 12 12 12 12 12 to make 1212121212
>
> Regards
>
> Matt
>
>

--
Christopher R. Spence
OCP, MCP, MCSE, A+, RAPTOR, CNA


Sent via Deja.com http://www.deja.com/
Before you buy.