dsd50
Last Activity: Oct 21 '15, 08:39 PM
Joined: Oct 21 '15
Location:
-
it is not math. the number to the right of the decimal is a counter. 1,2,3,4... 10, 11, 12 . The entire number and counter is stored in the same character field for some stupid reason; (101.1, 101.2 ... 101.10, 101.11) I inherited this code and would never design it this way. The 'sorting' code worked fine until the counter went to 2 digits, that is why I want 101.1 to really convert to 101.01 and not 101.10 -
I am trying to sort it descending to know the next incremental number to the right of decimal place. 101.11 should be the highest so I can increment to 101.12; 101.1 and 101.2 are the first and second entries ... 101.11 is the eleventh entry.Leave a comment:
-
I have tried converting to decimal but 101.1 and 101.10 both convert to 101.10; 101.2 converts to 101.20; I really need 101.1 to convert to 101.01 but I can't figure out how?Leave a comment:
-
dsd50 started a topic how to select and convert char value with decimal point to correct decimal placein SQL Serverhow to select and convert char value with decimal point to correct decimal place
hard to explain... i have a character field with a 'floating' decimal point and need to order it to get the next incremental decimal place but can't get the convert/cast to work after 1 place to the right of decimal. ie) 101.1, 101.2, ... 101.9, 101.10; problem is 101.10 and 101.11 order before 101.2
No activity results to display
Leave a comment: