>It's almost right. You don't need ALLTRIM though,and only need LOWER()/UPPER() only if the case of the data is different.
>

>UPDATE Table2 SET Column2 = TRIM(Table1.Column1) + TRIM(Table1.Column3) ;
>	FROM Table2 ;
>		INNER JOIN Table1 ON Table2.Column1 == Table1.Column2
>

>
>THre're no stupid questions, only stupid answers. :)

Both columns have to be the same length.

BTW, I think it's Borislav's tag line :)

Nope, I was wrong. It's probably Vlad's.