Hi,

I need to build a sql to determine no of digits in the decimal value.

For example

If value is 10.2123 then output should be 4
If value 10.212 then 3
If value 10.2 then 1 ..etc

Any idea how?

Thanks in advanace


Shri

You want to have the digits after the decimal point? If yes, then you can have a look at the value of the "scale" of the DECIMAL type. That value will tell you exactly how many significant digits are allowed. You can use a DESCRIBE statement on the results of a query to get that information.