SQL Query: Trim Spaces in from column field

SELECT     RTRIM(STUD_Student_ID) AS STUD_Student_ID, STUD_Forename_1, STUD_Surname
FROM         STUDstudent