how about:

STRIP ( CHAR ( column ) , L , '0' )

?

I'd suggest not to use REPLACE(...), as any '0' would be replaced by blanc ( not only the leading or trailing ones ).



*ups* I just saw that the original post is several years old ...