I need to use something like "switch" to define the new column in result. 

Example:

```
-----------------------
user_id | nick | role |
-----------------------
   1    | dupa |   A  |
   2    | geno |   U  |
   3    | mato |   E  |
-----------------------

```

Since A means "administrator", U means "default user" and E means "editor", I need to put new column to result and get the fullname of role. Something like this:

```
----------------------------------
user_id | nick | role | fullname |
----------------------------------
   1    | dupa |   A  |   admin  |
   2    | geno |   U  |   user   |
   3    | mato |   E  |  editor  |
----------------------------------

```

So it seems I need to use Switch, because there are more than 2 roles. If role = 'A', then fullname will be admin, and so on. How can I do that?

I have something like this for now:

```
SELECT
    user_ud, 
    nick, 
    role, 
    CASE
        WHEN role = 'A' THEN fullname = 'Admin' 
        WHEN role = 'E' THEN fullname = 'Editor'
        WHEN role = 'U' THEN fullname = 'User'
        ELSE fullname = NULL
    END
FROM 
    [tablename] ... 

```

But it doesn't work :(