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

Monday, May 16, 2011

t-sql remove diacritical marks and accents

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

posted @ 12:40 PM | Feedback (1)