There is a field with extra spaces at the end. I wanted to trim the spaces to right before displaying query output. rtrim won't work.

I also tried substr(fieldname,1,length(fieldname)). It still displays some spaces. But, substr(fieldname,1,30) displays 30 chars only. Any ideas?