Will this not work?

SELECT RTRIM(COMMENTS) FROM <table_name>