如何更改列中的记录长度?
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...