如何更改列中的记录长度? [关闭]

如何更改列中的记录长度?

In the customer2 table, change the name of the cities so that each record with the city is 2 characters shorter and there is an space instead of these characters.

In general, for each column entry, I must somehow determine the number of characters and remove the last 2 of them, then replace it with an ellipsis How should I use Len and replace for such a delicate matter?

I want to change records from column. For example: records - Paris, London, Moscow after modifying the column should look like this:

Par...

Lond... 

Mosc...