I assume you are talking about a 'text' in a record.
Then try:
repl (field_name) with left(field_name,len(alltr(field_name)-1))

or
lnAsc=asc(right(alltr(field_name),1))
repl (field_name) with strtran(field_name, chr(lnasc),"")


>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?