Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Phantom characters
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
Received on Tue Jan 16 2001 - 18:42:54 CST
![]() |
![]() |