如何去掉字段后面的空格，用SQL语句实现

去除左边空格LTRIM
SELECT LTRIM(column_name) FROM table_name WHERE 
去除右边空格RTRIM
SELECT RTRIM(column_name) FROM table_name WHERE 
去除前后空格TRIM
SELECT TRIM(column_name) FROM table_name WHERE 

listViewersetSorter(new ViewerSorter(){
public int compare(Viewer viewer, Object e1, Object e2) {
return ((Language)e1)genrecompareTo(((Language)e2)genre);
}
});

---