You should seriously consider storing a month in the date format. It'll make filtering and sorting much easier.
>
>I want to extract data from Table1 with following specification
>
>Table Name : Table1
>Field Name : Month1 C(7)
>
>Data in filed Month1 is as
>
>“01-2004”
>“03-2004”
>“08-2005”
>“09-2005”
>“01-2006”
>“01-2008”
>
>I want to extract data between following ragne.
>
>CVar1=”07-2005”
>Cvar2=”06-2006”
>
>Please Help
--sb--