check if string has special characters sql function code example

Example: sql column contains special character

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