quote:

---

The Squeeze function is used to remove the multiple occurences of spaces into one occurence.

---

quote:

---

Originally posted by mandm

Whatever the solution, you'll need to consider what will happen to words where this occurs naturally. What will happen to words like Cheese, Squeeze, Pass, Pattern?

---

quote:

---

Originally posted by ms65g

See

quote:

---

The Squeeze function is used to remove the multiple occurences of spaces into one occurence.

---

No.
My scenario is so different; the link technique is just for removing multiple spaces not other characters.

---

--Declaration string variables
DECLARE @s VARCHAR(500) = 'SSSSSSSSQQQQQQQLLLLLLLL                 Servvvvvvvvvverrrrr'
DECLARE @result VARCHAR(500)='';
 
--Publishing auxiliary sequence numbers table
WITH c AS 
(SELECT 1 AS n  
UNION ALL  
SELECT 1 + n FROM c WHERE n < 100),
c1 AS (SELECT n = ROW_NUMBER() OVER (ORDER BY (SELECT 1))
        FROM c c1
             CROSS JOIN c c2)
 
--Splitting the string with numbs table
, k AS
(SELECT n, k = SUBSTRING (@s, n, 1) 
  FROM c1 
 WHERE n <= LEN(@s))
 
--Filtering characters and then concatenating them
SELECT @result = @result + k
FROM k k1
WHERE NOT EXISTS 
    (SELECT * 
       FROM k k2 
      WHERE k1.k = k2.k 
        AND k1.n+1 = k2.n);
 
 
SELECT @result AS removed;

quote:

---

Originally posted by webfred

quote:

---

Originally posted by ms65g

See

quote:

---

The Squeeze function is used to remove the multiple occurences of spaces into one occurence.

---

No.
My scenario is so different; the link technique is just for removing multiple spaces not other characters.

---

A space is just a character. That's why I thought you are able to adapt it.
But sure you can keep on waiting for a complete solution

---

No, you're never too old to Yak'n'Roll if you're too young to die.

---

quote:

---

Originally posted by ms65g

Using numbers table is not a better solution against WHILW loop?

______________________

---

DECLARE @s VARCHAR(MAX);
SET @s = 'SSSSSSSQQQQQQLLLLL     SSSSSeeeervvvvveerr'

DECLARE @i INTEGER;
SET @i = 1;

WHILE @i <= 256
BEGIN
	IF CHARINDEX(CHAR(@i), @s) > 0
		SET @s = REPLACE(REPLACE(REPLACE(@s, CHAR(@i),CHAR(@i) + '~!@#$%^&*'), '~!@#$%^&*' + CHAR(@i),''), '~!@#$%^&*', ''); 
	SET @i = @i + 1;
END

SELECT @s AS [After]
/*
After
-----------
sql server  ----> I want thes be SQL Serve not sql server!
*/

quote:

---

Originally posted by khtan

a simple while loop to read each character and compare with previous char will do the job.

If your data is in a table, just create a UDF with above logic to do it.

---

KH
[spoiler]Time is always against us[/spoiler]

---

DECLARE @s VARCHAR(MAX);
SET @s = 'SSSSSSSQQQQQQLLLLL             SSSSSeeeervvvvveerr'

DECLARE @r VARCHAR(MAX);
SET @r = '';

DECLARE @i INTEGER;
SET @i = 1;

WHILE @i <= LEN(@s)
BEGIN
	IF @i = 1
		SET @r = SUBSTRING(@s, 1, 1);
	ELSE IF SUBSTRING(@s, @i, 1) <> SUBSTRING(@r, LEN(@r), 1)
	    SET @r = @r + SUBSTRING(@s, @i, 1);
				
	SET @i = @i + 1;
END

SELECT @r AS [Result]

--See! But I need remove duplicate space characters during the function!
/*
Result
-------------------------
SQL             Server
*/

WHILE @i <= LEN(@s)
BEGIN
	IF @i = 1
		SET @r = SUBSTRING(@s, 1, 1);
	ELSE IF SUBSTRING(@s , @i, 1) <> SUBSTRING(@r, LEN(@r+'1')-1, 1)
	    SET @r = @r + SUBSTRING(@s, @i, 1);
				
	SET @i = @i + 1;
END