Snowflake SQL. Select column value if 1st 5 characters are numeric and within a Numeric Range
I have a column named ProcedureCode VARCHAR(16777216) in a Table named ProcedureCode.
It has values like ‘12345,46H’, ‘A4715,12W’, ‘98765’, ‘99200’ etc.
I have a column named ProcedureCode VARCHAR(16777216) in a Table named ProcedureCode.
It has values like ‘12345,46H’, ‘A4715,12W’, ‘98765’, ‘99200’ etc.