Is this a small enough number of rows that you can identify all of them and
their primary key or unique index values? if so, you can update that field
using substr(field,2) and remove the first character
>From: David Barbour <dbarbour_at_connectsouth.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Phantom characters
>Date: Tue, 16 Jan 2001 16:45:19 -0800
>
>Greetings,
>
>I've got some entries in one of my columns that appear to contain a leading
>space or spaces. When I try to use ltrim, they don't go away. If I spool
>the data, I find these spaces are actually represented in the spool file as
>/240. I don't have this number as an ascii, decimal or octal
>representation
>of anything, and am at a loss as to how to identify and remove these
>"phantoms". Any ideas?
>
>David A. Barbour
>Oracle DBA - ConnectSouth
>512-681-9438
>dbarbour_at_connectsouth.com
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: David Barbour
> INET: dbarbour_at_connectsouth.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
Get your FREE download of MSN Explorer at
http://explorer.msn.com
Received on Tue Jan 16 2001 - 19:51:09 CST
