주민등록컬럼 varchar(14) (790101-1111111)이 일때
CASE SUBSTRING(주민등록컬럼,8,1)
WHEN 1 THEN YEAR(GETDATE()) - ((left(MEM_Resident,2) + 1900) )
WHEN 2 THEN YEAR(GETDATE()) - ((left(MEM_Resident,2) + 1900) )
WHEN 3 THEN YEAR(GETDATE()) - ((left(MEM_Resident,2) + 2000) )
WHEN 4 THEN YEAR(GETDATE()) - ((left(MEM_Resident,2) + 2000) ) END AS [나이],
CASE SUBSTRING(주민등록컬럼, 8, 1)
WHEN 1 THEN '남'
WHEN 3 THEN '남'
WHEN 2 THEN '여
WHEN 4 THEN '여' END AS [성별],
아래는 샘플 ㅎㅎ