Hi,
I have records as below

Name         Date         Action
--------------------------------
John         01/01/2005    Y
John         01/03/2005    T
John         01/04/2005    F

I need to transform these records to :

Name         Date         Date2        Action
---------------------------------------------
John         01/01/2005   28/02/2005     Y
John         01/03/2005   31/03/2005     T
John         01/04/2005   / /            F

The date of next record will be the date2 of current record.

Any way to do this in SINGLE SQL statement (VFP/SQL Server)?
Currently I am using UDF() in SELECT list. Any other ways?

Thank you