In our example, the REPLACE function is expected to remove the unwanted character (CHAR(0)). Try to run a SELECT query for the specific column and apply a REPLACE() operation and make sure those characters are removed from the query result.

if that does not work, pls post some sample data. I will have a look at it and see If i can help you with this.

regards

Jacob