Talk:String concatenation

From Rosetta Code

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)
select into seems to be a non-standard extension to sql which is mostly used for creating backups of data in existing tables. Here, though, we have three lines -- the first two lines are analogous to variable declaration and variable assignment, and the last line illustrates the task requirement. That said, note that this || mechanism is the ansi standard way to concatenate string (introduced in sql-92) and some implementations of sql (such as mysql) do not support this syntax. --Rdm 19:28, 16 November 2010 (UTC)
Stick with the ANSI standard; the deviants can have their own entries (or at least their own sub-solution). –Donal Fellows 23:40, 16 November 2010 (UTC)

Rexx ||[edit]

|| may be piping in some other language(s), In Rexx it's called concatenate! abc'xyc' is called abuttal. While 'abc'def worke like a charm 'Walter'b or 'Johnny'x do not Rexx takes the b and x to mean bit or hex string Beware of b and x as variable names --Walterpachl 11:12, 28 January 2013 (UTC)