CREATE FUNCTION [players].[normalize_string] ( @input NVARCHAR(100) ) RETURNS NVARCHAR(100) AS BEGIN DECLARE @output NVARCHAR(100) SET @input = LOWER(UPPER(@input)) set @output = @input set @output = REPLACE(@output,'ı','i') set @output = REPLACE(@output,'ş','s') set @output = REPLACE(@output,'ç','c') set @output = REPLACE(@output,'ö','o') set @output = REPLACE(@output,'ğ','g') set @output = REPLACE(@output,'ü','u') set @output = REPLACE(@output,'@','') set @output = REPLACE(@output,'-','') set @output = REPLACE(@output,'.','') set @output = REPLACE(@output,',','') set @output = REPLACE(@output,'?','') set @output = REPLACE(@output,'*','') set @output = REPLACE(@output,'_','') set @output = REPLACE(@output,'=','') set @output = REPLACE(@output,')','') set @output = REPLACE(@output,'(','') set @output = REPLACE(@output,'/','') set @output = REPLACE(@output,'&','') set @output = REPLACE(@output,'%','') set @output = REPLACE(@output,'+','') set @output = REPLACE(@output,'!','') set @output = REPLACE(@output,' ','') return (@output) END