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

3 votes332 views1 answer
Start mysql server linux terminal
SQL
9 votes302 views6 answers
Sql add column with default value
SQL
2 votes299 views1 answer
Drop table purge
SQL
0 vote352 views1 answer
How to convert external table to managed table in hive
SQL
2 votes309 views1 answer
Oracle percentage
SQL
0 vote289 views1 answer
Increment id in mysql
SQL
0 vote251 views2 answers
Illuminate\Database\QueryExceptionSQLSTATE[HY000] [2002] No such file or directory
SQL
0 vote342 views1 answer
Sql ssrs
SQL
0 vote308 views1 answer
How to select only id where is not in column mysql
SQL
0 vote301 views2 answers
Pg_restore: error: input file appears to be a text format dump. Please use psql.
SQL