Answers for "a column contains a character sql"

sql column contains special character

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

Posted by: Guest on January-14-2021

sql query to check if column contains alphabets

SELECT * 
FROM table_name
WHERE CAST(PRIME_KEY AS STRING) RLIKE '([0-9]+[a-z]+)'

Posted by: Guest on February-02-2021

Code answers related to "a column contains a character sql"