Function to Remove Non-Alpha Numeric VAlues

CREATE FUNCTION [dbo].[RemoveNonAlphaNumericCharacters](@Temp VarChar(1000)) Returns VarChar(1000)AS
BEGIN
While PatIndex('%[^a-zA-Z0-9]%', @Temp)> 0 --AND PatIndex('+', @Temp) > 0 Set @Temp = Stuff(@Temp, PatIndex('%[^a-zA-Z0-9]%', @Temp), 1, '')
Return @TEmp
END
--Calling the function with an example
SELECT dbo.[RemoveNonAlphaNumericCharacters]('Abc1234def5678ghi90jk))l+;-')

--Output
Abc1234def5678ghi90jkl