0 - 1 of 1 tags for trailing spaces

Hello,

My table tbl has a column col which has the below definition:-
COL VARCHAR(250) CHARACTER SET UNICODE NOT CASESPECIFIC TITLE 'COL'

I am trying to trim spaces on the data in the this col. I used TRIM and what I see in the result is that it trims leading spaces but not the trailing spaces. I have tried various combinations in the query below:-

SEL COL,CHARACTER_LENGTH(COL),COL||'-',
TRIM(COL) a,CHARACTER_LENGTH(a),A||'-',
TRIM(TRAILING' ' FROM COL) B,charACTER_length(B),B||'-',
TRIM(TRAILING' ' FROM CAST(COL AS VARCHAR(2000))) C,CHARACTER_length(C),C||'-',