how to remove spaces in and of text field

I have field X that contains text with spaces in the end of the text.

How I can remove them?

I need it in any SQL query for ora开发者_StackOverflow中文版cle 10g.

---

Strictly speaking if you want to only remove trailing spaces then you'd use RTrim(). LTrim() is leading spaces and Trim() is both.

---

select trim(COLUMN_NAME) from .......
;