Replace Values by Select-Statement

[schwertfeger]

Hi,
i've on Table with people and one boolean for sex. I try to create one Querry, which replace or creates a new column, where instead of sex=true/false the string male/female can be read.

I tried with
SELECT DISTINCT name, REPLACE(sex, false, 'male') AS sex FROM ...

But the rest of the world is represented by 0 instead of 'female' and i can't access this new column.

Thanks,
BS