>Hi All:
> I am trying to replace only a year value in a datetime filed on a SQL 7.0 table with a current year. For example, if the value is 05/27/2001, I want this to be 05/27/2002. Is there a function in SQL 7.0 (like "STUFF" in VFP) that could help me accomplish my goal.
>
You can use Datepart() and Dateadd() functions as follows
DECLARE @dt datetime
SET @dt = '05/27/2000'
SELECT @dt, DATEADD(Year, 2002 - DATEPART(year, @dt), @dt)
-- Update
UPDATE mytable SET DTfield = DATEADD(Year, 2002 - DATEPART(year, DTfield ), DTfield )
--sb--