Remove special characters from string using MS-SQL Procedure

Hi All, now I'm discussing how to remove special characters from a string in SQL Server using store procedure. For ASCII code help you can follow this http://www.asciitable.com/

Now, I write a store procedure in SQL Server 2008.

CREATE PROCEDURE ASCII_Spl_Char_SP

(@STRING VARCHAR(8000))

AS BEGIN

CREATE TABLE #TEMPTABLE (ASCII_Value INT, LETTER VARCHAR(1))

SET TEXTSIZE 0

SET NOCOUNT ON

DECLARE @POSITION INT

DECLARE @TEXT AS VARCHAR(8000)

SET @POSITION = 1

WHILE @POSITION <= DATALENGTH(@STRING)

   BEGIN

      INSERT INTO #TEMPTABLE

      SELECT ASCII(SUBSTRING(@STRING, @POSITION, 1)),

                  CHAR(ASCII(SUBSTRING(@STRING, @POSITION, 1)))

    SET @POSITION = @POSITION + 1

   END

      UPDATE #TEMPTABLE SET LETTER = '', ASCII_Value = (SELECT ASCII(''))

      WHERE ASCII_Value IN (0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,128,129,130,131,132,133,134,135,                                136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,                                    166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,                                    196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,                                    226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255)

SET NOCOUNT OFF

-- SELECT * FROM #TEMPTABLE

SELECT @TEXT = COALESCE(@TEXT,'') + LETTER FROM #TEMPTABLE

SELECT @TEXT

END

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

Now Execute the store procedure with string parameter.

EXEC ASCII_Spl_Char_SP 'Hi, Th£is is Arkça Guüpèta.'

The Result will be : Hi, This is Arka Gupta.