Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
dev:sql:functions:concatenation [2010/07/09 20:08]
els
dev:sql:functions:concatenation [2016/06/28 22:38] (current)
Line 6: Line 6:
 The concatenation operator - || (two vertical bars) - returns a single concatenated character string made up of two or more character expressions. All blanks are preserved during concatenation. Use the TRIM function to eliminate blanks if desired. ​ The concatenation operator - || (two vertical bars) - returns a single concatenated character string made up of two or more character expressions. All blanks are preserved during concatenation. Use the TRIM function to eliminate blanks if desired. ​
  
-A concatenation operator on two character strings (CHARACTER_DATATYPE_COLUMN1 || CHARACTER_DATATYPE_COLUMN2) will return a CHARACTER string; everything else will return a STRING.+A concatenation operator on two character strings (CHARACTER_DATATYPE_COLUMN1 || CHARACTER_DATATYPE_COLUMN2) will return a CHARACTER string; everything else will return a STRING.
  
 ===== Syntax ===== ===== Syntax =====
 
Back to top
dev/sql/functions/concatenation.txt ยท Last modified: 2016/06/28 22:38 (external edit)