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.
1 Answers
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')
Related