Hi,

At the part of eliminate duplicate what if we have a '!' character in string?

So following solution is so simple and suitable for any scenario.

And I use a new way for publishing numbers table.

DECLARE @s-2 VARCHAR(500)='aaaaaaaaaaaaaaaaaaaaaaaaaaaaaffffffffffffffffffffffffdddddddddddd ghqwer a d qqqq [pppp]'

DECLARE @result VARCHAR(500)='';

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)

, k AS

(SELECT n, k = SUBSTRING (@s, n, 1)

FROM c1

WHERE n <= LEN(@s))

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;

/*

removed

-----------------------

afd ghqwer a d q [p]