CREATE FUNCTION dbo.remove_nonascii( @InputString VARCHAR(max) ) RETURNS VARCHAR(max) BEGIN IF @InputString IS NULL RETURN NULL DECLARE @OutputString VARCHAR(8000) SET @OutputString = '' DECLARE @l INT SET @l = LEN(@InputString) DECLARE @p INT SET @p = 1 WHILE @p <= @l BEGIN DECLARE @c INT SET @c = ASCII(SUBSTRING(@InputString, @p, 1)) IF @c BETWEEN 0 AND 127 SET @OutputString = @OutputString + CHAR(@c) SET @p = @p + 1 END IF LEN(@OutputString) = 0 RETURN '' RETURN @OutputString END example use: SELECT av9_comment_1 AS Before ,sl.dbo.remove_nonascii(av9_comment_1) AS After FROM [av0_style_comment_eng] http://www.asciitable.com/

http://www.connectsql.com/2011/05/sql-server-how-to-remove-special.html

UPDATE [av0_style_comment_eng] SET av9_comment_1 = sl.dbo.remove_nonascii(av9_comment_1) ,av9_comment_2 = sl.dbo.remove_nonascii(av9_comment_2) ,av9_comment_3 = sl.dbo.remove_nonascii(av9_comment_3) ,av9_comment_4 = sl.dbo.remove_nonascii(av9_comment_4) ,av9_comment_5 = sl.dbo.remove_nonascii(av9_comment_5) ,av9_comment_6 = sl.dbo.remove_nonascii(av9_comment_6) 02.04.16

• Home
• Notebook
• Contact us

• Privacy Statement
• 

Copyleft ☠ 2024