Remove special characters from string using MS-SQL Function

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

Now, I write a function in SQL Server 2008.

CREATE FUNCTION ASCII_Spl_Char_Fnc (@STRING VARCHAR(8000)) RETURNS VARCHAR(8000)

AS BEGIN

DECLARE @TEMPTABLE TABLE (ASCII_Value INT, LETTER VARCHAR(1))

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)

-- SELECT * FROM @TEMPTABLE

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

RETURN @TEXT

END

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

Now run this function with string variable.

SELECT dbo.ASCII_Spl_Char_Fnc('Hi, Th£is is Arkça Guüpèta.')

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