DECLARE @teststring nvarchar(max) SET @teststring = 'Test''Me' SELECT 'IS ALPHANUMERIC: ' + @teststring WHERE @teststring NOT LIKE '%[-!#%&+,./:;<=>@`{|}~"()*\_^?[]'']%' {ESCAPE ''}