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

/* in Oracle */

select fname, lname, sex, decode(sex,'M','male','F','female','unknown?') 
from student



/* in MySql or SQLite use replace( )  or case */