Freek's Blog

SQL en .NET vraagstukken en oplossingen die ik zoal tegenkom
posts - 199, comments - 123, trackbacks - 2, articles - 7

My Links

News

Google analytics script: Locations of visitors to this page

Article Categories

Archives

Post Categories

Image Galleries

Algemene links

MSDN

vb links

t-sql remove diacritical marks and accents

Posted on Monday, May 16, 2011 12:40 PM

alter FUNCTION fnRemoveAccents(@String VARCHAR(1000))

RETURNS VARCHAR(1000)

AS

BEGIN

SET @String = REPLACE(@String,'','n')

SET @String = REPLACE(@String,'','e')

SET @String = REPLACE(@String,'','e')

SET @String = REPLACE(@String,'','e')

SET @String = REPLACE(@String,'','e')

SET @String = REPLACE(@String,'','o')

SET @String = REPLACE(@String,'','o')

SET @String = REPLACE(@String,'','o')

SET @String = REPLACE(@String,'','o')

SET @String = REPLACE(@String,'','o')

SET @String = REPLACE(@String,'','i')

SET @String = REPLACE(@String,'','i')

SET @String = REPLACE(@String,'','i')

SET @String = REPLACE(@String,'','a')

SET @String = REPLACE(@String,'','a')

SET @String = REPLACE(@String,'','a')

SET @String = REPLACE(@String,'','a')

SET @String = REPLACE(@String,'','y')

SET @String = REPLACE(@String,'','y')

SET @String = REPLACE(@String,'','u')

SET @String = REPLACE(@String,'','u')

SET @String = REPLACE(@String,'','u')

RETURN (SELECT @String)

END

Feedback

# re: t-sql remove diacritical marks and accents

7/25/2011 5:21 AM by 数据修复
Thanks

Post Comment

Title  
Name  
Url
Comment   

ATTENTION: the code you need to copy is CaSe SeNsItIvE and is required to prevent spam.
Enter the code you see: