how to find if the record has special value sql code example

Example: sql column contains special character

SELECT Col1
FROM TABLE
WHERE Col1 like '%[^a-Z0-9]%'