Re: trailing spaces

Update table_name
set char_column = rtrim(char_column)

and that for all tables.

Hth,

Sybrand Bakker, Oracle DBA

Steve A <spectre_at_hkstar.com> wrote in message news:1dw9pqj.ll5kopf3fcjeN@[201.1.1.73]...
> Hi,
> I've just inported rather alot of data into oracle 8 from foxpro
> I wrote the convesion programs based on the assumption that varchar2
> stripped any trailing spaces.
> I allocated 15 places for a string that is normally 10
>
> However I can only get the following query to work with the trailing
> spaces.
> What I really cannot figure is that I have a lot of this form of data,
> and some selects work on some tables, minus the trailing spaces, but the
> conversion was the same for all.
>
> "SELECT * FROM reldat where link02_88='CROC0O5SHZ '"
>
> nothing else will work
>
>
> Is there any utility I can run my databases thru to remove /cure the
> problem, without having to re-import all the data
Received on Sun Aug 08 1999 - 23:54:12 CDT