How to Concatenate String Data of Table in SQL

In this article I am going to explain how to concatenate string data in database Table.
  • 2442

Introduction

In this article I am going to explain how to concatenate string data in one column from more than one column stored in database table.  To combine or concatenate columns and data stored in these columns, we use concatenate operator ( + ).  A string expression can consist one or more columns.

A Statement that create vendors table

ven.jpg

Statements that insert data in vendors table

ven (1).jpg

A Statement that is used to fetch data from vendors table

ven (2).jpg

A Statement that concatenate string data

Clipboard02.jpg

A Statement that concatenate string data using literal values

Clipboard04.jpg


© 2019 DotNetHeaven. All rights reserved.