Report Builder and the TRIM function

Has anyone figured out how to truncate or trim the "~" from a field? I have
the following calculated field set up TRIM(SalesRepList,~ ) and it is not
changing the result from what I get when using the salesreplist by itself.
Any ideas?


Jim Frice