Uso:
Select dbo.replaceAccentCharAndEnieUpper('123ÁáéíóúñÑ456')
Resultado:
123AAEIOUNN456
Función:
CREATE FUNCTION replaceAccentCharAndEnieUpper (@source as varchar(255))
RETURNS varchar(255) AS
BEGIN
declare @charList as varchar(20)
declare @temp as varchar(255)
declare @i as int
set @temp = @source
set @charList = 'aeiou'
set @i = 0
while @i <= len(@charList)
begin
set @temp = replace(@temp, substring(@charList, @i, 1) , substring(@charList, @i, 1) )
set @i = @i + 1
end
set @temp = Replace(@temp, '’', '''')
set @temp = Replace(@temp, 'ñ', 'n')
set @temp = Upper(@temp)
return @temp
END
Fuente:
