lcPeriod = "07-2007"
SELECT Table1
DELETE FOR month = lcPeriod

>
>Table1 has only one field as
>
>month c(7)
>
>and data in table is as
>
>06-2007
>06-2007
>07-2006
>07-2007
>07-2007
>08-2007
>07-2007
>
>Now I want to delete all enteries containing 07-2007
>For this, I use this command but it does not work
>

>curmon=07-2007
>lnMonths3 = Val(Substr(curmon , At("-", curmon )+1)) * 12 + Val(curmon ) - 1
>CVAR3 = Str(Int(lnMonths3 / 12), 4)+Padl(Int(lnMonths3) % 12 + 1, 2, "0")
>Select Table1
>delete for month=m.cvar3
>pack
>

>In 07-2007, 07 is month and 2007 is year
>I use British date
>
>Please help