Just Learned - CONCAT - Used to concatenate two or more strings in SQL Server Denali CTP3

Getting Started with Adobe After Effects - Part 6: Motion Blur


	Just Learned

A collection of quick technology learning tips from what people around you learn every day


	Submit a tip


	Subscribe..

Home · Most Liked · Most Learned · Most Discussed · Silver Rated · Sections

CONCAT - Used to concatenate two or more strings in SQL Server Denali CTP3

Jul 15 2011 10:57AM by Paresh Prajapati

I just installed SQL Server 11 CTP3 in my machine and started to review new functionalities. One feature I learned is CONCAT(tsql function) which is used to concatenate two or more strings. This function requires 2 to 254 arguments.

SELECT 'FirstName' + ' ' + 'LastName' -- SQL Server any version
SELECT CONCAT('FirstName',' ','LastName' ) -- SQL Server Denali CTP3
-- Output : FirstName LastName

Above code return same output.

3 Comments

This function is already in Oracle and Mysql. I suggest to use this function that normal "+" operator. If we use CONCAT() function instead of "+" operator, In future, while migrating database to other languages, it will be useful.

commented on Jul 15 2011 11:00AM

Ramireddy

2 · 41% · 12972

Of course, it's not an aggregate function, though, is it? :(

Another Oracle function I wish SQL Server had is GREATEST.

commented on Jul 15 2011 11:05AM

ErikEckhardt

65 · 3% · 887

Erik,

Probably they might add it in next version as this is in mysql also. Looks like sql server wants to support the functions supported by other languages also...

commented on Jul 15 2011 11:47AM

Ramireddy

2 · 41% · 12972

Your Comment

Sign Up or Login to post a comment.

"CONCAT - Used to concatenate two or more strings in SQL Server Denali CTP3" rated 5 out of 5 by 8 readers +Paresh Prajapati