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