SET DATE ANSI SET CENTURY ON REPLACE BORN_DATE WITH CTOD([19]+RIGHT((DTOC(BORN_DATE)),8)) FOR YEAR(BORN_DATE)>2000