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

0 vote125 views1 answer
Sql output select
SQL
0 vote124 views1 answer
Fetching data from mysqldb
SQL
3 votes118 views2 answers
Host is not allowed to connect to this mysql server
SQL
0 vote135 views1 answer
Insert into table with only identity column
SQL
104 votes283 views2 answers
Like in mysql
SQL
1 vote61 views1 answer
Full text index mysql
SQL
0 vote108 views1 answer
Mysql_union
SQL
15 votes117 views4 answers
Pl sql
SQL
0 vote110 views1 answer
Sql where part of string match
SQL
0 vote101 views1 answer
Opening xampp mysql in cmd ubuntu
SQL