snowflake stored procedure with special characters not working

I want to identify the phone number is in correct format or not. e.g. format. (XXX) XXX-XXXX Here is the sql that is working fine select RLIKE( ‘(800) 456-7891’, ‘\\([0-9]{3}\\) [0-9]{3}-[0-9]{4}’ ) ; But when tried to replicate this function inside store procedure, i am not able to get the desired results Here is stored… Read More snowflake stored procedure with special characters not working