TRIM seems to not work...

From: Rocky Welch <rockyw_99_at_yahoo.com>
Date: Fri, 19 Jan 2001 13:03:33 -0800 (PST)
Message-Id: <10746.127191@fatcity.com>

--0-1373930043-979938213=:25885
Content-Type: text/plain; charset=us-ascii

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! Mail. --0-1373930043-979938213=:25885
Content-Type: text/html; charset=us-ascii

<P>Hi Gang,
<P>HAPPY FRIDAY!
<P>I'm having a problem with the trim function on 8.1.6 running on Solaris 8. Here is the code:</P><FONT face=r_ansi size=2>
<P>spool /export/home/mp5i/r5prompts/input/user.txt;</P>
<P>select TRIM(TRAILING ' ' FROM usr_code)</P>
<P>from r5users;</P>
<P>spool off;</P>
<P><FONT face=Arial>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.</FONT></P>
<P><FONT face=Arial>TIA,</FONT></P>
<P><FONT face=Arial>-Rocky</FONT></P></FONT><p><br><hr size=1><b>Do You Yahoo!?</b><br>
<a href="http://personal.mail.yahoo.com/">Yahoo! Mail Personal Address</a> -
Get email at your own domain with Yahoo! Mail. Received on Fri Jan 19 2001 - 15:03:33 CST