convert numeric values in colomn into names

And make all your unknowns males.

SELECT *,
CASE 
    WHEN Gender = 0 THEN 'Female' 
    when Gender = 1 then 'Male'
    ELSE NULL END As GenderName
FROM yourTable