74674982327500000000 = 7.47E+19 in Excel develop into 07467498232750E7 in SQL Large Question. The “E” turns into an alphabet as an alternative of the multiplication




I want the “E” to multiply the quantity as an alternative of being an alphabet as a result of I need to filter primarily based on their size. The quantity belongs to a column whose schema is ready to strings as a result of many of the worth are distinctive ids made up of a mix of alphabets and numbers. Just a few of them wrongly made up of simply numbers.

Excel

SQL


Leave a Reply

Your email address will not be published. Required fields are marked *