trailing spaces

From: Steve A <spectre_at_hkstar.com>
Date: Mon, 9 Aug 1999 11:47:20 +0800
Message-ID: <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 - 22:47:20 CDT