---
title: "Combining two columns data into one using SQL Server"  
description: "Combining two columns data into one using SQL Server"  
author: "Anonymous User"  
published: 2014-09-22  
updated: 2014-09-22  
canonical: https://www.mindstick.com/forum/2264/combining-two-columns-data-into-one-using-sql-server  
category: "database"  
tags: ["database"]  
reading_time: 1 minute  

---

# Combining two columns data into one using SQL Server

I have a [table](https://www.mindstick.com/articles/43918/how-to-design-table-using-bootstrap):

```
CREATE TABLE CombineCoulmns(       columnA varchar(15),       columnB varchar(15)) 
```

With some [records](https://www.mindstick.com/forum/34640/how-to-create-a-stored-procedure-for-display-all-records):

## columnA columnB

One Five

Two Six

Three Seven

Four Eight

I want to show the record as [result](https://www.mindstick.com/blog/12011/advantages-of-getting-result-oriented-seo-from-an-agency) as following:

## comineColumn

One

Two

Three

Four

Five

Six

Seven

Eight

I attempt do this:

```
select columnA+columnB as combineColumn from CombineCoulmns;
```

but it give different Result:

## comineColumn

OneFive

TwoSix

ThreeSeven

FourEight

Please help me.

## Replies

### Reply by Anchal Kesharwani

hi tanuj,\

You should try to **UNION** operation for this task:

```
select columnA as columnNamefrom CombineCoulmnsunionselect columnB as combineName from CombineCoulmns
```

**Note:** **UNION** will keep only one record in case of duplicate values between columnA and columnB. If you want to see the duplicate values repeated in your result, use the **UNION ALL** operation instead.


---

Original Source: https://www.mindstick.com/forum/2264/combining-two-columns-data-into-one-using-sql-server

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.