SQL – Concatenate

Concatenate

Note, when joining two or more fields together, both fields must be a
string value.  If one of the fields is a numeric value, the numeric field
must be converted to a string.

SQL Server:

SELECT Emp_LastName + ', ' + Emp_FirstName FROM Employee;
Returns 'LastName, FirstName'

Oracle:

Two pipe symbols (||) are used to concatenate values in Oracle

SELECT Emp_LastName || ', ' || Emp_FirstName FROM Employee;

The CONCAT Function can only join two strings together.  If you need to
join more than two strings, you will need to use the method above.

SELECT CONCAT(Emp_LastName, Emp_FirstName) FROM Employee;
Returns 'LastName, FirstName'

 

Advertisements
About

Over 20 years programming experience 5 years Oracle SQL/Stored Procedure programming Over 10 years SQL 2000/2005/2008 Server SQL/Stored Procedure programming Over 18 years Visual Basic 3.0/4.0/5.0/6.0/.Net/2003/2005/2008/2010/2015 Over 10 years ASP.Net Over 7 years Visual C# Over 20 years Microsoft Office and VBA HTML JAVA COBOL EASYTRIEVE FORTRAN

Tagged with: , , , ,
Posted in Oracle, SQL Server

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: