convert numeric values in colomn into names

You can do it with a simple CASE WHEN Statement:

SELECT *
      ,CASE WHEN Gender = 0 THEN 'female' ELSE 'male' END As GenderName
FROM yourTable

---

Olaf Helper

[ Blog] [ Xing] [ MVP]