Differences

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

Link to this comparison view

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.1278706135.txt.gz ยท Last modified: 2016/06/28 22:38 (external edit)
 
 
chimeric.de = chi`s home Valid CSS Driven by DokuWiki do yourself a favour and use a real browser - get firefox!! Recent changes RSS feed Valid XHTML 1.0