03-07-2013 11:33 AM
I have a dataset which have 5 digit codes. I want to make it 4 digit codes and so i used substr to get until the 4th digit.
Example: 140.41, 140.42, 140.43 become 140.4 now
After this I want to retain the first description to the rest of 140.4' s . In this example MOUTH
Could anyone help me with this