General information
Category:
Coding, syntax & commands
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?
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only