T-SQL 替换多个空格
DECLARE @Demo TABLE(OriginalString NVARCHAR(4000)) INSERT INTO @Demo (OriginalString) SELECT ' I am Incognito, What just for a test!' UNION ALL SELECT '看看 效果 吧!' UNION ALL SELECT '也许 大概？！ 可能' UNION ALL SELECT '我 不知道啊。 谢谢 ！' UNION ALL SELECT 'English is Okey!.'--===== Reduce each group of multiple spaces to a single space -- for a whole table without functions, loops, or other -- forms of slow RBAR. In the following example, CHAR(7) -- is the "unlikely" character that "X" was used for in -- the explanation. SELECT REPLACE( REPLACE( REPLACE( LTRIM(RTRIM(OriginalString)) ,' ',' '+CHAR(7)) --Changes 2 spaces to the OX model ,CHAR(7)+' ','') --Changes the XO model to nothing ,CHAR(7),'') AS CleanString --Changes the remaining X's to nothing FROM @Demo WHERE CHARINDEX(' ',OriginalString) > 0