请教高手MSSQL去空格问题？THK！

请看以下例子 谢谢！
例子

    A(字段)
------------------------
a b  c
ab  c
f c d


结果:

    A(字段)
------------------------去掉所有的空格只留字符
abc
abc
fcd

---

replace(a,' ','')

---

SQL code:
update a set a=replace(a,char(32),'')

---

SQL code:
SELECT
A,REPLACE(A,' ','')
from TB

---

SQL code:

update tb
set A=replace(A,' ','')




??

---

SQL code:
--> 生成测试数据表:tb

IF NOT OBJECT_ID('[tb]') IS NULL
DROP TABLE [tb]
GO
CREATE TABLE [tb]([A] NVARCHAR(10))
INSERT [tb]
SELECT 'a b c' UNION ALL
SELECT 'ab c ' UNION ALL
SELECT 'f c d '
GO
--SELECT * from [tb]

-->SQL查询如下:
UPDATE tb SET
a=REPLACE(a,CHAR(32),'')

SELECT * from tb
/*
A
----------
abc
abc
fcd

(3 行受影响)

*/

---

SQL code

---

Code highlighting produced by Actipro C