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;
- What about select into? I was never sure how SQL-fu like that worked, though. --Mwn3d 04:58, 16 November 2010 (UTC)