General MySQL Oracle SQL Server

Concatenating Two Character Strings in SQL Server

Q

How To Concatenate Two Character Strings Together in SQL Server Transact-SQL?

✍: FYIcenter.com

A

Concatenating two character strings together is most commonly used string operation. SQL Server 2005 allows to concatenate two character strings into a single string with the (+) operator. The following tutorial exercise shows you some string concatenation examples: 

DECLARE @site VARCHAR(40);
SET @site = 'FYIcenter.com';
SELECT 'Welcome to '+@site;
SELECT 'Current date and time is '
   +CONVERT(VARCHAR(20), GETDATE());
GO
Welcome to FYIcenter.com
Current date and time is May 19 2007  5:18PM

DECLARE @start INT, @end INT, @total INT;
SET @start = 21; 
SET @end = 30;
SET @total = 728;
SELECT 'Search result '
   + CONVERT(VARCHAR(20),@start)
   + ' - '
   + CONVERT(VARCHAR(20),@end)
   + ' of '
   + CONVERT(VARCHAR(20),@total);
GO
Search result 21 - 30 of 728

 

⇒ String Type Conversion During Concatenation in SQL Server

⇐ Character Strings and Binary Strings in SQL Server Transact-SQL

⇑ Character Strings and Binary Strings in SQL Server Transact-SQL

⇑⇑ SQL Server Transact-SQL Tutorials

2017-03-11, 6340🔥, 0💬

General MySQL Oracle SQL Server