如何删除多余的空格！！，，急啊

Question

select replace('a a   a',' ','')

Answer 1

update tb set 备注=replace( 备注,' ','')

Answer 2

declare @str1 varchar(50)
set @str1='fjkads我们   jfkda 都来   了！'
select @str1 
select replace(@str1,' ','')
--------------------------------
                                                   
-------------------------------------------------- 
fjkads我们   jfkda 都来   了！（所影响的行数为 1 行）                                                                                                                                                                                                                                                                 
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 
fjkads我们jfkda都来了！（所影响的行数为 1 行）