Query to find wildcard / special characters in Snowflake REGEXP_LIKE
Problem statement: To find all the records with special characters (with characters outside the range a-Z0-9)
SELECT * FROM MY_TABLE WHERE REGEXP_LIKE(ColumnA, '.*[^a-zA-Z0-9].*');
Enjoy great content like this and a lot more !
Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds