Summary:
Removing last character of a variable length string.

Question:
How can the last character of each string in a column be removed?

Answer:
This can be done through Table>Update Column. Set the Table to Update to the desired table. Set the Column to Update to the column containing the string value. Get Value from Table should be the same table listed in Table to Update. Value should be the following string:

left$(<column name>, len(<column name>)-1)

Click OK to perform the update and File>Save Table to save the changes to the table.

 

 

 

 

Reference:

MapInfo Products Knowledge Base