select pat_ben_vc, mat_ben_vc, nom_ben_vc, IIF(cod_sex_bi=1, 'Masculino', 'Femenino') AS SEXO, CONVERT(INT, DATEDIFF(DAY,fec_nac_ben_da, CONVERT(VARCHAR(200), GETDATE(), 112))/365) AS EDAD from Beneficiario