RE: TRIM seems to not work...

From: Jeffery Stevenson <jeff_at_mpv.com>
Date: Fri, 19 Jan 2001 16:08:45 -0600
Message-Id: <10746.127197@fatcity.com>

Just make sure to use SET TRIMSPOOL ON when spooling lines to a file, I think that might be what is causing all of your trailing spaces. HTH

Jeffery Stevenson
Chief Databeast Tamer
Medical Present Value, Inc.
Austin, TX

-----Original Message-----

From: Rocky Welch [mailto:rockyw_99_at_yahoo.com] Sent: Friday, January 19, 2001 3:06 PM
To: Multiple recipients of list ORACLE-L Subject: TRIM seems to not work...

Hi Gang,
HAPPY FRIDAY!
I'm having a problem with the trim function on 8.1.6 running on Solaris 8. Here is the code:
spool /export/home/mp5i/r5prompts/input/user.txt; select TRIM(TRAILING ' ' FROM usr_code)
from r5users;
spool off;
When I edit the file produced there are trailing blanks after the data. Am I missing something here? I just want the data without the trailing blanks afterward.
TIA,
-Rocky

Do You Yahoo!?
Yahoo! Mail Personal Address - Get email at your own domain with Yahoo! Received on Fri Jan 19 2001 - 16:08:45 CST