Question: Not sure if this is possible to do using SQL. Any type of database server is okay to use to test it.

I have a table called category which looks like this below,

```
  Gender  |  Age
 -----------------
    M     |   25
    M     |   36
    F     |   22
    M     |   54
    F     |   28
    F     |   41

```

When I use,  

`SELECT GENDER * FROM CATEGORY`   

```
   Gender     
    M        
    M        
    F        
    M        
    F  
    F

```

I am wondering if there is a way to do any kind of modification with the data in the table when we pull the column without making any change with the data in the existing table.

I want something like this below,

```
    Gender     
    Male        
    Male        
    Female        
    Male        
    Female  
    Female

```

I do not want to change the data in the table. Is there a way, I can add something to the SELECT query to get the above details from my table?

Answer: 
As @GordonLinoff suggested in the comments:

```
SELECT CASE WHEN Gender='M' THEN 'Male' WHEN Gender='F' THEN 'Female' END as Gender
FROM Category;

```
```
select case Gender 
        when 'M' then 'Male' 
        when 'F' then 'Female' 
        else 'Other' 
    end as Gender
from Category

```