Have you looked at rtrim?

-
Cameron Hanover
chanover AT umich DOT edu

"Our integrity sells for so little, but it is all we really have. It is the 
very last inch of us, but within that inch, we are free."
--Valerie (V for Vendetta)

On Oct 2, 2014, at 10:29 AM, Lee, Gary <GLEE AT BSU DOT EDU> wrote:

> Looked in the db2 manuals, didn't see what I wanted.
> 
> Tsm 6.2.5 under RHEL 6.1
> 
> Is there a way to trim trailing whitespace from string fields within a select 
> statement?
> 
> Looked at the trim function, but it didn't appear to be what I needed.
> 
> Thanks for the help.