<< Click to Display Table of Contents >> Navigation:  Notes on Local SQL > Concatenation using plus (+)

The original Local SQL documentation says string concatenation is done using double pipes (||).

However, BDE 5.2.0.2 also accepts the common plus (+) character, which is both easier to type and more comfortable to read.

SELECT

  LastName + ", " + FirstName AS e."Full Name"

FROM

  Employee e;

 

Supplementary notes on LocalSQL added by Niels Knabe