CODE EXAMPLE FOR SQL

how to find special characters in sql

/* Select Special Charcters only*/
select col1
	from table_name
    	where col1 like '%[!@#$%^&*]%'; 
        
Note : You can add any special character in WHERE clause