DECLARE @pattern varchar(52) = '0123456789 abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ' SELECT v.[Text], REPLACE( TRANSLATE( v.[Text], REPLACE(TRANSLATE(v.[Text], @pattern, REPLICATE('a', LEN(@pattern))), 'a', ''), REPLICATE('~', LEN(REPLACE(REPLACE(TRANSLATE(v.[Text], @pattern, REPLICATE('a', LEN(@pattern))), 'a', ''), ' ', '.'))) ), '~', '' ) AS AlphaNumericCharacters FROM (VALUES ('abc01234def5678ghi90jkl#@$&"'), ('1234567890'), ('JAHDBESBN%*#*@*($E*sd55bn') ) v ([Text]);