You're welcome. Sorry for incorrect original suggestion. I didn't notice that it was for MS SQL server, not for VFP.

>Works like a champ!
>
>Thanks
>
>>Try (not tested)

SELECT plan, begindate
>>	FROM mytable
>>	WHERE begindate IN (
>>		SELECT TOP 2 begindate
>>		FROM mytable
>>		ORDER BY begindate DESC)
>>UNION ALL
>>	SELECT MAX(plan) + 1, CAST(Null AS D)
>>	FROM mytable
>>ORDER BY begindate DESC
>>

>>