how to check string contains special characters in sql code example Example: sql column contains special character SELECT Col1 FROM TABLE WHERE Col1 like '%[^a-Z0-9]%'