I have a table **Port** with data like the following:

```
Name
-------
ADSL 1
ADSL 2
Ethernet 1
Ethernet 2

```

and I want to transform the data to:

```
Name
-------
Port 1
Port 2
Port 1
Port 2

```

How can I do a

```
update Port set name =  somereplacmentlogic(name)

```

Thanks!