I'm trying to update a SQL Server, but the text I'm updating with has a special ascii character at the end. It looks like a little box at the end of all the records. If I manually get rid of the character, SQL updates correctly. Does anyone know if there is a way to progammatically delete this special character?