select a field from a column

[dunk2]

Hi,

How do I select a field from a numeric column?
Example. I want to sum the fourth digit after the decimal place, typical number= 26.2345 so I want to select '5' and then sum this.

Thanks in advance.

 

[michaelkrauklis]

This might not be what you're looking for, but you can simply multiply the number by 10000 and then take modulo 10. Not the most efficient way to do it but the first thing that poped into my head. Almost by definition, floating point operations are not going to be efficient. Good luck. MYenigmaSELF:-9
myenigmaself@myenigmaself.gaiden.com

http://myenigmaself.gaiden.com

"If debugging is the process of removing bugs, then programming must be the process of putting them in." --Dykstra