/* display a different value based on existing column value */


select fname, lname, sex, replace(replace(sex,'M','Male'),'F','Female') 
from student