How do you concatenate in DB2 SQL?

Answer

The concatenate operator can be indicated by two ways in DB2 SQL. You can either use CONCAT or alternatively, use double bars (||) for the concatenation operation. CONCAT, however, is mostly preferred.
Q&A Related to "How do you concatenate in DB2 SQL?"
You can download the following IBM redbook: http://www.redbooks.ibm.co. m/abstract. s/sg246503.html?Open. It's be a great start with many good examples. HTH, DaveSlash.
http://www.experts-exchange.com/Database/DB2/Q_277...
1. Open a SQL command line. 2. Select the fields you wish to join, separated by the concatenation operator, with the following command: SELECT city || state. 3. Specify the table
http://www.ehow.com/how_11368625_concatenate-db2-s...
Disclaimer: This is a very generic and quick comparison. For any details, feel free to reach to me directly. Oracle: Great scalability and availability, DR, replication, high cost
http://www.quora.com/Oracle/What-are-the-relative-...
I am trying to write a query where it will strip -CN from a name field in my table. Not sure how to do this. Column Name = CUSTOMER_NAME, Table Name = CUSTOMER_TABLE AS newName FROM
https://answers.yahoo.com/question/index?qid=20100...
About -  Privacy -  Careers -  Ask Blog -  Mobile -  Help -  Feedback  -  Sitemap  © 2014 Ask.com