1. CREATE FUNCTION [players].[normalize_string] ( @input NVARCHAR(100) ) RETURNS NVARCHAR(100)
2. AS
3. BEGIN
4.     DECLARE @output NVARCHAR(100)
5.     SET @input = LOWER(UPPER(@input))
6.     set @output = @input
7.     set @output = REPLACE(@output,'ı','i')
8.     set @output = REPLACE(@output,'ş','s')
9.     set @output = REPLACE(@output,'ç','c')
10.     set @output = REPLACE(@output,'ö','o')
11.     set @output = REPLACE(@output,'ğ','g')
12.     set @output = REPLACE(@output,'ü','u')
13.     set @output = REPLACE(@output,'@','')
14.     set @output = REPLACE(@output,'-','')
15.     set @output = REPLACE(@output,'.','')
16.     set @output = REPLACE(@output,',','')
17.     set @output = REPLACE(@output,'?','')
18.     set @output = REPLACE(@output,'*','')
19.     set @output = REPLACE(@output,'_','')
20.     set @output = REPLACE(@output,'=','')
21.     set @output = REPLACE(@output,')','')
22.     set @output = REPLACE(@output,'(','')
23.     set @output = REPLACE(@output,'/','')
24.     set @output = REPLACE(@output,'&','')
25.     set @output = REPLACE(@output,'%','')
26.     set @output = REPLACE(@output,'+','')
27.     set @output = REPLACE(@output,'!','')
28.     set @output = REPLACE(@output,' ','')
29.     return (@output)
30. END