UPDATE testTable
SET testNtext = REPLACE(CAST(testNtext AS NVARCHAR(1000)),' ',' ')
WHERE testNtext LIKE '% %'
SET testNtext = REPLACE(CAST(testNtext AS NVARCHAR(1000)),' ',' ')
WHERE testNtext LIKE '% %'
|
UPDATE testTable
SET testNtext = REPLACE(CAST(testNtext AS NVARCHAR(1000)),' ',' ') WHERE testNtext LIKE '% %'
|