0 - 3 of 3 tags for for update

Using MSSQL 2000. I have a table with duplicate rows that needs to be updated. I have new values with similar table.
Table A:
UID        Type
11796     30
11796     31
11796     48
11556     302
11556     305
11552     146
 
Table B:
UID        Type
11796     50

Hi, I'm Sebastian and I need your help you. I have rows with '    ' data, for example:
My table have 1 row of the name 'tx_name' and... in the name have:
'     Pepito'(in that case use trim for remove )
'Pepito      Albert'(How remove it this space?)
I try with: