[RESOLVED] update years from 190x to 200x

I had some dates that got imported incorrectly and I need to update them. It assumed everything that came in as xx/xx/0x was xx/xx/190x. How do I update the years in all those fields to be 200x??

Nevermind. I got it:

"UPDATE CompRemoved SET DateRemoved = DateAdd(year, 100, DateRemoved)"

:)

something like this should work for Sql Server:
tabledate = dateadd(year,100,tabledate)

edit:
too slow :)