Ms sql filter all sympbol

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

Source: stackoverflow.com

Similar codes

7 votes188 views2 answers
Create index mysql
SQL
0 vote177 views1 answer
Drop constraint in ms sql
SQL
0 vote172 views1 answer
Postrgres trunc
SQL
0 vote173 views1 answer
How to connect pgadmin with excel
SQL
0 vote189 views1 answer
Bidirectional outer join sql
SQL
28 votes186 views6 answers
Mysql change user password
SQL
0 vote182 views3 answers
ChAnge TABLE name apex oracle
SQL
0 vote179 views2 answers
Default constraint in ms sql
SQL
10 votes179 views2 answers
Mysql alter add foreign key
SQL
1 vote189 views1 answer
Oracle apex run 404
SQL