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]);
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter