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. We're going to empty and reload this database pretty soon with newer data and I'll look into fixing the Java code to do the right thing, but I'm just curious.

I'm using Firebird 2.1.

Thanks,

Michael D. Spence
Mockingbird Data Systems, Inc.