--这样试一下
Declare @t Table(A Varchar(50))
Insert @t Select 'adasd sdfsd'
Select * From @t
--测试
Select A=Replace(A,' ',char(32)+char(32))
From @t
Declare @t Table(A Varchar(50))
Insert @t Select 'adasd sdfsd'
Select * From @t
--测试
Select A=Replace(A,' ',char(32)+char(32))
From @t
Returns Varchar(1000)
As
Begin
While CharIndex(' ',@S)>0
Select @S=Replace(@S,' ',' ')
Return @S
End
GO
Select dbo.RemoveSpace('adasd sdfsd fdgdfg')
Select dbo.RemoveSpace('dsadsa kkkk dfg')
--Result
/*
adasd sdfsd fdgdfg
dsadsa kkkk dfg
*/
BEGIN
declare @out_str varchar(4000)set @out_str=@in_strif charindex(char(32)+char(32), @in_str)>0
set @out_str= dbo.fn_Trim_Space(replace(@out_str,cast(char(32)+char(32) as varchar),char(32)))return @out_strEND不過比paoluo(一天到晚游泳的鱼)的差多了謝謝 paoluo(一天到晚游泳的鱼)