[SQL] Write a SnowSql query to fetch only matching numbers from colA

Column A Column B
163963511000005388900000 163963511000005388999999
370266002932704000000000 370266002932704999999999
543215000000000000000000 543215999999999999999999
718700000000000000000000 718799999999999999999999

Output ColA 1639635110000053889 370266002932704 543215 7187

Need to compare cola colb index by index and return till number match

Need to write snowsql query

Continue reading...