declare @ids nvarchar(max); set @ids=N‘5936593066,5936556893,59366 00375,5936594808,59 36624757,5936625206‘ declare @char char(2); set @char=N‘ ‘ --5936593066,5936556893,5936600375,5936594808,5936624757,5936625206 select replace(@ids,@char,‘‘)
原文：http://www.cnblogs.com/yy3b2007com/p/5231798.html