Find special characters from the column of the table
Below is the simple SQL query to find those records from the table that contain special characters. Simply create a table, insert some data into it containing special characters or copy and paste the below code in to query window and execute. DECLARE @data AS TABLE ( RecordId INT IDENTITY , TextData VARCHAR ( 100 )) INSERT INTO @data ( TextData ) VALUES ( 'hello abc' ), ( 'hello $hyam' ), ( 'testing % char' ), ( 'hello ram' ), ( 'hello.' ), ( 'testing # now' ), ( 'testing @ now and ! also' ), ( 'why lefting ^me and & me too' ) SELECT * FROM @data WHERE TextData LIKE '%[^a-zA-Z0-9,.()* ]%'