I have a column named ProcedureCode VARCHAR(16777216) in a Table named ProcedureCode.
It has values like ‘12345,46H’, ‘A4715,12W’, ‘98765’, ‘99200’ etc.

From that Table, I need to pull only rows where the 1st 5 characters are Numeric and
the 1st 5 characters fall within a range 99200 – 99499.

In T-SQL, I would use IsNumeric() to determine if the 1st 5 characters of the string are numeric [but I can’t use IsNumeric () in Snowflake]. Then I would Cast the 1st 5 characters as Numeric. Then I would test if the 1st 5 are in my range.

I don’t know how to do this in Snowflake.

I would appreciate any pointers/help I can get.

Thanks!