This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
dev:sql:functions:concatenation [2009/12/04 22:51] tdo created |
dev:sql:functions:concatenation [2012/10/26 14:28] (current) |
||
|---|---|---|---|
| Line 8: | Line 8: | ||
| All blanks are preserved during concatenation. Use the TRIM function to eliminate blanks if desired. | All blanks are preserved during concatenation. Use the TRIM function to eliminate blanks if desired. | ||
| ===== Syntax ===== | ===== Syntax ===== | ||
| - | string || string[ || string[...]] | + | [ < column_spec | "string" > || < column_spec | "string " > |
| + | [ || <column_spec | "string "[...] ] | ||
| ===== Examples ===== | ===== Examples ===== | ||
| - | ==== Example 1 ==== | + | ==== Example 1: Column + text + Column ==== |
| <code SQL> | <code SQL> | ||
| select company, | select company, | ||