Problem with select options
I have an select options for field perid whose type is Char with length 7.
so my inputs are like AUG'08 , JUL'08 ,JAN'08 .....for perid.
my problem is perid-low if i am taking JUL'08 and
perid-high taking as AUG'08..
so here as perid is of type char, it is taking the ascii value of J and A and throwing message as Lower limit cannot be greater than Higher Limit... how can i avoid this ....
if i am taking lowerlimit as AUG'08 and upper limit as JUL'08 then it is working fine......
Please helpfull answers will be highly appreciated..