What is the difference between INNER JOIN and OUTER JOIN?

Update rows based other rows in the same column

Bauer

I am using SQL Server and I need to update the value of rows based on the similar value of data in the same column. My column looks like this...

| column_1 |
-------------
|6311837240
|6311837240
|6311837240
|6311837240
|COSU6311837240
|COSU6311837240
|6311837240
|6311837240
|6311837240
|COSU6311837240
|COSU6311837240

I want to update all rows that = 6311837240 to COSU6311837240 recognizing that the right digits match. The logic needs to be dynamic at the length is not consistent.