30 October 2018 · Asran ·       Add to Favorites   Report

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)

Solution:

SELECT * FROM MY_TABLE WHERE REGEXP_LIKE(ColumnA, '.*[^a-zA-Z0-9].*');


Asran

posted on 30 October 2018

Read great educational content like this and a lot more !

Members get free exclusive access to content, new courses, and discounts. Signup for a free account to write a post / comment / upvote posts. Creating an account takes less than 5 seconds and you can start earning badges & points too

Copied