Break down versions into an integer - SQL

Question

I'm trying to break down versions into integers.

for example, from 14.4 to 14 or from 9.4.1 to 9

How can I define the number until the dot?

Thanks.

Answer 1

you can try SPLIT_PART https://docs.snowflake.com/en/sql-reference/functions/split_part.html

select Split_part(column1,'.',0) col1 from values ('14.4') ,('9.4.1') , ('12345.5656')