Sql CONCAT() function
The CONCAT function introduced in SQL Server 2012, This function concatenating two or more string values and returns a string value.
Syntax:
CONCAT( string1, string2 ,.....stringN)
Exapmle:- Following is "EMPLOYEE" table where i am going to apply the CONCAT function
The CONCAT function introduced in SQL Server 2012, This function concatenating two or more string values and returns a string value.
Syntax:
CONCAT( string1, string2 ,.....stringN)
Exapmle:- Following is "EMPLOYEE" table where i am going to apply the CONCAT function
Id
|
Name
|
Age
|
1
|
Alok Kumar Singh
|
30
|
2
|
Tomas Paul
|
45
|
3
|
Cristomfer Dee
|
85
|
4
|
Niel Macengi
|
55
|
SELECT CONCAT(NAME,'-',ADDRESS,'-',AGE) AS EMPDetail FROM EMPLOYEE
Result:-
EMPDetail
|
Id
|
Alok Kumar Singh -IN-30
|
1
|
Tomas Paul-NZ-45
|
2
|
Cristomfer Dee-AU-85
|
3
|
Niel Macengi-US-55
|
4
|
No comments:
Post a comment