This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | Next revision Both sides next revision | ||
|
dev:sql:functions:concatenation [2010/07/09 03:32] els |
dev:sql:functions:concatenation [2010/07/09 03:33] els |
||
|---|---|---|---|
| Line 13: | Line 13: | ||
| ===== Examples ===== | ===== Examples ===== | ||
| - | ==== Example 1: Column + text + Column ==== | + | ==== Example 1: Concatenating both columns and text ==== |
| <code> | <code> | ||
| > select 'Individual: ' || individual || ' Name: ' || name first_line from individuals; | > select 'Individual: ' || individual || ' Name: ' || name first_line from individuals; | ||