Highlights
All Snippets
Top 100 Snippets
Librarians
gbCodeLib

By Language
VB6
JavaScript
Perl
HTML
SQL
Java
DOS

GBIC >> Source Code >> SQL >> Snippet

Concatenation


the || ( DOUBLE pipe) concatenates two string:
note that SOME applications use the plus ( + ) sign TO concatenate strings:
SELECT firstname || lastname (EntireName), phone   FROM  customers
OR
SELECT firstname   ||   ","   ||  lastname (EntireName), phone   FROM  customers