How can I remove duplicate numbers containing text?

I have a table that looks like this:

|StreetName NR| NR |
|Teststreet 34| 34 |

How can i delete only 开发者_开发问答the number in Streetname when it is the same in NR??

---

UPDATE
    Addresses
SET
    StreetName = LEFT( StreetName, LEN( StreetName ) - LEN ( StreetNo ) )
WHERE
    StreetName LIKE '%'+StreetNo