At 12:29 AM 6/06/2009, you wrote:

>I've got a table with a VARCHAR field which has trailing non-printing characters in it (loaded by JDBC). Strange things happen when I try to use concatenation, but I don't find this particularly surprising all things considered.
>
>What I would like to know, though, is if there's any way using a builtin that I can trim the trailing characters on this field. TRIM(MYFLD) doesn't do anything.

trim removes whitespace characters.

Did you try REPLACE() ? (Provided you know what the characters are, of course...)

./hb