Summary:

How to update a new column with an address from an existing column, without the street number.

Question:
How to update a new column with an address from an existing column, without the street number?

Answer:
The following is an example on how to update a column in a MapInfo table with the street name excluding the street number. In this example, streetcol is the field that contains both the street number and street name.

If a new character column has not been added to the table, add it through Table>Maintenance>Table Structure. Update this new column through Table >Update Column using the following expression:

Right$(streetcol, len(streetcol) - instr(1, streetcol, " "))

Reference:

MapInfo Products Knowledge Base