I have a CYC_CD field which is VARCHAR. The values of this field indicate the cycle run code For Example 0109M(January 09 run), 1209M (December 09 run) so on so forth. When I convert it to an integer and use MAX function it gives me incorrect result becauase technically 0310M is the Max run and not 0409M .
Is there a way where I can pick up the MAX value in the text field. In my case pick up 0310M record and not 0409M record ?