the data I'm using to fill my dropdown is coming from a DB table. The field data type is char(50). Not all the fields are 50 characters long. Is there a way to get rid of the trailing spaces?