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.

Thanks
MA