SELECT membFNme, memberIdNum, MAX(DATEDIFF (YY,substring(memberIdNum, 1,6), GETDATE())) FROM member GROUP BY membFNme HAVING = MAX (DATEDIFF (YY,substring(memberIdNum, 1,6), GETDATE
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)