 |
| |
[01/14/2010]
DB2: How do I concatenate multiple columns in a select statement to return a single column?
By: Mark Jacobsen
Use "||" like so...
SELECT LastName||', '||FirstName
FROM [schema].[table]
===================
Mark Jacobsen: I hope you have found this article or tip helpful. If so, please consider making a donation. 100% of all proceeds will be directed to charity: water.
Contact me at MarkJacobsen.net or @MarkJacobsen
|
|
 |
Thanks for stopping by. Please be sure to visit some of my sites for your communication needs: Toll Free Virtual PBX, Real Estate Call Capture, Hosted PBX, and Virtual Fax.
All News Articles...
|
|
