To get number of actual decimal places for a number

 

 

Select Len(Cast(Reverse(Substring(Cast(4.23400 as varchar(50)), patindex('%.%', Cast(4.23400 as varchar(50)))+1,100)) as Int))