Question: How to change My result set in `sql server 2012`

My Result set is

```
Name   Age   Gender
 X      21     M
 Y      21     F

```

I need this type of result

```
Name|Age|Gender
X|21|M
Y|21|f

```

Including column names

Answer: 
Try this:

Press **Ctrl+T** to get this.

[![enter image description here](https://i.stack.imgur.com/LDoeA.png)](https://i.stack.imgur.com/LDoeA.png)
I think this will work

```
 select Convert(nvarchar(50),name)+'|'+Convert(nvarchar(50),age)+'|'+Convert(nvarchar(50),gender) as column from table_name

```