Cacher is the code snippet organizer for pro developers

CREATE function [dbo].[RemoveSpecialChars] (@s nvarchar(4000)) returns nvarchar(4000)
begin
-------------------------------------------------------------------------------------------------
----------------- Removes all characters which are not in (0-9)(a-z)(A-Z)(æÆøØåÅ)
-------------------------------------------------------------------------------------------------
   if @s is null
      return null

   declare @s2 nvarchar(4000)
   set @s2 = ''

   declare @l int
   set @l = len(@s)

   declare @p int
   set @p = 1

   while @p <= @l begin
      declare @c int
      set @c = ascii(substring(@s, @p, 1))
      if   @c between 48 and 57 --0-9
		or @c between 65 and 90 -- A-Z
		or @c between 97 and 122 --a-z
		or @c = 230  --æ
		or @c = 198  --Æ
		or @c = 248  --ø
		or @c = 216  --Ø
		or @c = 229  --å
		or @c = 197  --Å
         set @s2 = @s2 + char(@c)
      set @p = @p + 1
      end
   if len(@s2) = 0
      return null
   return @s2
   end
GO