how to remove spaces in and of text field - need it in and sql query for oracle

Question

i have field X that contain text with spaces in the end of the text

how i can remove them ?

i need it in any sql query for oracle 10g

Answer 1

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

K

Answer 2

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