' -----------------------------------------------------------------------------
'                                       DTT 1.2.0.4  (c)2008 FSL - FreeSoftLand
'  Title: Concatenation
' 
'  Date : 01/04/2008
'  By   : Juan Pedro
' -----------------------------------------------------------------------------

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


