Dear Experts
AC1=1001
mon1="08-2005"
Select month;
from paybook;
where ACCNO=AC1 and ;
month<mon1;
into cursor pastbp
select pastbp
it shows months as
"07-2005"
"01-2006"
"02-2006"
"03-2006"
"04-2006"
"05-2006"
It must only show month="07-2005" because it is less than mon1
While month field in paybook is character type.
Please help to collect exact months
Thanks in advance