select pat_ben_vc, mat_ben_vc, nom_ben_vc,
case cod_sex_bi
when 0 then 'femenena'
when 1 then 'macheto'
else 'transsexual transexual'
end
AS SEXO,
CONVERT(INT,
DATEDIFF(DAY,fec_nac_ben_da,
CONVERT(VARCHAR(200),
GETDATE(), 112))/365) AS EDAD
from Beneficiario