Arrghh David beat me to it! 😛
CREATE FUNCTION dbo.FN_REMOVEL_VOWELS (@STRING VARCHAR(max))
returns varchar(max)
as
begin
RETURN REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(@STRING, 'A', ''), 'E', ''), 'O', ''), 'U', ''), 'I', '')
END
SELECT DBO.FN_REMOVEL_VOWELS('INFORMATION SYSTEM')
Quick note about your original function. Don't RETURN VARCHAR unless you know your string is never more than 8 characters long.
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn