Sample Header Ad - 728x90

How to count decimals without zeros

2 votes
2 answers
3273 views
How can I count all decimal place up to the first zero For example I have a column named x with an entry of numeric datatype value 1.955000000 I want to count the decimal places without the zeros. So here I want the query to make an output of 3 not 9 (with zeros)
Asked by DataLordDev (63 rep)
Aug 12, 2019, 08:02 AM
Last activity: Sep 13, 2021, 06:50 PM