Talk:String concatenation

SQL has string concatentation using infix || in the style of PL/1 but does not have variables as such.

create table foo ( a varchar(10),b varchar(10)); insert into foo values ('hello','dolly'),('l8r','g8r'); select 'greeting is ' ||a ,a ||' '|| b from foo;