请教SQL语句的编写

[denise_zeng]

SQL语句中怎样去掉字段里的空格及回车符.

[chuifengde]

replace([Field],' ','')
replace([Field],char(10)+char(13),'')

[昵称被占用了]

replace(
replace(
replace(字段,' ','') ---去空格
,char(13),'') --去回车
,char(10),'') --去回车

[梅小西Echo]

不会把，我觉得他自动会转换把

[kk19840210]

replace(字段名,' ','')
replace(字段名,char(13),'')

[clothfish]

select replace(replace(字段,' ',''),char(13)+char(10),'') from table

[chuifengde]

写倒了：回车换行是replace([Field],char(13)+char(10),'')

[fa_ge]

天空老大正解

[denise_zeng]

非常感谢各位....

[denise_zeng]

SELECT REPLACE(REPLACE(workid, ' ', ''), CHAR(13) + CHAR(10), '') AS Expr1

Expr1
W10600017
W10500051
W10600017
W10500051
"W10501188
"
值W10501188后仍有回车符哦.....

[denise_zeng]

请高手指点哦...

[ojuju10]

select replace(replace(replace([Field],' ',''),char(10),''),char(13),'') from tablename

[anison]

mark

[ojuju10]

declare @v varchar(30)
set @v='fd dfd fd dff
a'

select replace(replace(replace(@v,' ',''),char(10),''),char(13),'')

----
fddfdfddffa

[denise_zeng]

ok 了.....感谢感谢!!!!!