I have to find a way to count the number of decimal places for each row in my column and then sort my the largest value based on the number of decimal places.
I need the data to look like this after I run the query
I was trying the len() function but that didn't return the right number of characters.
2.23902101900000000000 9.43434000000000000000 51.10000000000000000000 11.00000000000000000000 0
Keep in mind that I don't count trailing zeros, if you want to count those then take out the 2 replace functions
Denis The SQL Menace
Here is a sample, but you have to convert col1 to a character.
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?